8 Replies Latest reply: Jun 18, 2015 9:23 AM by Rajat Sharma

# Number Formatting Linear Gauge

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!

• ###### Re: Number Formatting Linear Gauge

Hi there.

See example attached.

Kind regards,

Ernesto.

• ###### Re: Number Formatting Linear Gauge

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

• ###### Re: Number Formatting Linear Gauge

In the Number tab of properties, set these

• ###### Re: Number Formatting Linear Gauge

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

• ###### Re: Number Formatting Linear Gauge

Can you attach a QVW?

• ###### Re: Number Formatting Linear Gauge

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

• ###### Re: Number Formatting Linear Gauge

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);

\$(vFormatNumber(sales)) as salesFormat;
AutoGenerate 4;
```

hope this helps

regards

Marco

• ###### Re: Number Formatting Linear Gauge

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