Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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!

1 Solution

Accepted Solutions
consenit
Contributor II

Re: Number Formatting Linear Gauge

Hi there.

See example attached.

Kind regards,

Ernesto.

8 Replies
consenit
Contributor II

Re: Number Formatting Linear Gauge

Hi there.

See example attached.

Kind regards,

Ernesto.

Not applicable

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

Capture.PNG

reshmakala
Contributor III

Re: Number Formatting Linear Gauge

In the Number tab of properties, set these

Not applicable

Re: Number Formatting Linear Gauge

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

reshmakala
Contributor III

Re: Number Formatting Linear Gauge

Can you attach a QVW?

Not applicable

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

LOAD *,

    $(vFormatNumber(sales)) as salesFormat;

LOAD Ceil(Rand()*3000000) as sales

AutoGenerate 4;

QlikCommunity_Thread_148462_Pic1.JPG

QlikCommunity_Thread_148462_Pic2.JPG

hope this helps

regards

Marco

Not applicable

Re: Number Formatting Linear Gauge

I have made it look like this gauge!

Capture.PNG

I will post the QVD for people to use it! its from Qliksense and i created it in qlikview

Community Browser