Qlik Sense documentation and resources.
*** Sorry **** Content is removed as editing the base javascript files is Support License Agreement Violation ***
Hi Michael,
Would you please confirm if that will only work in a pivot table?
When could we expect that be resolved in QlikSense ?
Kind regards,
Jorge
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.
NUM(SUM([Net Income])/vUnit,IF(vUnit=1,'#,##0',IF(vUnit=1000,'#,##0K',IF(vUnit=1000000,'#,##0M',IF(vUnit=1000000000,'#,##0B')))))
Hi johnwatson12,
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 "
Don't forget to upvote this idea:
1 month ago, the feedback was valued by the
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
Hi Everyone.
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)
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';
3:k = 1000
6:M = 1 000 000
etc
-3:m = 0.001 (this will display as 1m)
-6:μ = 0.000001 (this will display as 1μ)
etc
Hope this helps!
Thanks
Kingsley
Hello All,
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!