Number Formatting Linear Gauge

[#1]

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!

[consenit · Accepted solution]

Hi there.

See example attached.

Kind regards,

Ernesto.

[#3]

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

[reshmakala]

In the Number tab of properties, set these

[#5]

Thats the problem it should be simple as that but it does not work.. the values stay the same!

[reshmakala]

Can you attach a QVW?

[#7]

I wouldnt want to put all that company information public.. So i don't think i can do that.

[MarcoWedel]

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

[#9]

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