Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Qlik Sense

You're reading from   Mastering Qlik Sense Expert techniques on self-service data analytics to create enterprise ready Business Intelligence solutions

Arrow left icon
Product type Paperback
Published in Mar 2018
Publisher Packt
ISBN-13 9781783554027
Length 514 pages
Edition 1st Edition
Languages
Arrow right icon
Authors (2):
Arrow left icon
Martin Mahler Martin Mahler
Author Profile Icon Martin Mahler
Martin Mahler
Juan Ignacio Vitantonio Juan Ignacio Vitantonio
Author Profile Icon Juan Ignacio Vitantonio
Juan Ignacio Vitantonio
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

Preface 1. Qlik Sense Self-Service Model FREE CHAPTER 2. Transitioning from QlikView to Qlik Sense 3. Security Rules: Attribute Based Access Control 4. Master Items in Qlik Sense 5. Qlik Sense on the Cloud 6. Qlik Sense Data Modeling 7. Best Practices for Loading Data in Qlik Sense 8. Advanced Scripting 9. Advanced Expressions in Qlik Sense 10. Overview of Qlik Sense APIs 11. Working with the Qlik Dev Hub 12. Coding in Qlik Sense 13. Creating Extensions in Qlik Sense 14. Integrating QS in Websites via Mashups 15. Other Books You May Enjoy

Formatting settings through variables

Before we start coding, we should first set the foundations that will allow us to properly set up formats as well as ways of handling values, for example, nulls or dates. This is important because different regions have different formats. Let's take the United States as an example. Numbers in the United States use commas to represent thousands and dots to represent decimals. For example, one thousand and thirty hundredths in its numerical form is 1,000.30. However, most of the countries in Latin America would use dots as a thousand separator and commas for hundredths separators: 1.000,30.

Another very important value where the format changes depending on the region is the date. Dates can be represented in different ways. For example, 2018-08-08 where we have four digits for the year, two for the month, and two for the day, or 30-01-2019...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image