Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am new to Qlikview.. I just started the book Qlikview for Developers 11 and i currently am at chapter 8 and i would like to apply some of the things i have learned to my work but i am having a weird problem.
I have a linear Gauge.. with 4 Major Units so...
500,000$
1,000,000$
1,500,000$
2,000,000$
I would like to change the number format to..
500K
1M
1.5M
2M
But when i enter the symbol K M or B in to the corresponding fields.. My values do not change.
Thanks!
Hi there.
See example attached.
Kind regards,
Ernesto.
Hi Ernesto! That worked great but the problem is it only works for values in the millions... i want it to be more responsive in the sense that my linear gauge has 500,000$ and 1,000,000$ i want it to convert the 500,000$ to 500K and 1,000,000$ To 1M here is a picture of my gauge.. below
In the Number tab of properties, set these
Thats the problem it should be simple as that but it does not work.. the values stay the same!
Can you attach a QVW?
I wouldnt want to put all that company information public.. So i don't think i can do that.
Hi,
to convert the actual values, you could use:
SET vSize = Div(Log10($1),3);
SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0.0')&' '&Pick($(vSize($1)),'K','M','B','T'),$1);
LOAD *,
$(vFormatNumber(sales)) as salesFormat;
LOAD Ceil(Rand()*3000000) as sales
AutoGenerate 4;
hope this helps
regards
Marco
I have made it look like this gauge!
I will post the QVD for people to use it! its from Qliksense and i created it in qlikview