Documents about Qlik Sense.
Would you please confirm if that will only work in a pivot table?
When could we expect that be resolved in QlikSense ?
Below is a solution that we got to work in Qlik Sense in KPIs, tables, and charts. It is not dynamic, in the sense that you need to expose to the users a filter on a field (island in data model) called "Unit", which has text values: Base, Thousands, Millions, Billions, etc. You then create a variable called vUnit, that calculates =IF(ONLY(Unit)='Thousands',1000) .... etc. continuing the if statement. The formula below then switches to B in KPIs, tables, or charts for example.
pay attention, in your solution you replace the value with the label and if you have different units in the same sequence, there is the risk that chart or the sort is not accurate anymore. By the way, the final solution is right here on this page, just sharp your sight and spot the difference. Please be sure to use "The Solution", just in your custom code or extension, as override method, to avoid to infringe the license and the integrity of QlikSense or at least use with discretion to escape from the lawyers of the "igabyte" designer team with their "Guns".
Don't forget to upvote this idea:
1 month ago, the feedback was valued by the igabyte (or igahertz?) team, the fix requires 2-3 minutes. Perhaps, we will get in the next minor release! Yahoo!
this can now be achieved by simply modifying the set statement in theits simple and easy and takes a few seconds you can change the symbols to anything you like .. from April 2018 release
To change the billions abbreviation in Qlik Sense, follow these steps:
Go to your load editor
Go to your Main section
The last SET expression is what you want to manipulate (Change G to B)
3:k = 1000
6:M = 1 000 000
-3:m = 0.001 (this will display as 1m)
-6:μ = 0.000001 (this will display as 1μ)
Hope this helps!
I have a similar issue in bar chart legend number format , as following post:
Having tried to remove num funtion in measure expression and put it on measure number format by customs. or with auto number, it can show K or M in bar graph well unfortunately without currency mark set in front. To use the '3:k;6:M;...' also was tried but didn't work out.
My problem is, that the legend number format keeps in 2.71k, while on the bar chart it was 2,706K.
Can you help me out how to make them in consistency? thanks!