topic Re: Number Formatting Linear Gauge in QlikView

Number Formatting Linear Gauge

Wed, 14 Jan 2015 19:58:30 GMT

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

1.5M

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

consenit — Wed, 14 Jan 2015 20:20:07 GMT

Hi there.

See example attached.

Kind regards,

Ernesto.

Re: Number Formatting Linear Gauge

Wed, 14 Jan 2015 20:24:03 GMT

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

reshmakala — Wed, 14 Jan 2015 20:27:30 GMT

In the Number tab of properties, set these

Re: Number Formatting Linear Gauge

Wed, 14 Jan 2015 20:29:40 GMT

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

Re: Number Formatting Linear Gauge

reshmakala — Wed, 14 Jan 2015 20:35:21 GMT

Can you attach a QVW?

Re: Number Formatting Linear Gauge

Wed, 14 Jan 2015 20:37:51 GMT

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

Re: Number Formatting Linear Gauge

MarcoWedel — Wed, 14 Jan 2015 21:04:37 GMT

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

Re: Number Formatting Linear Gauge

Thu, 18 Jun 2015 13:23:59 GMT

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