Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Money values in terms of K

Hi All,

I wanted to display money in terms of K.

Ex: I have data like this 1000000 should be represented as 1000k

can anyone suggest how to do this? or any better alternative since number of zero's creates confusion

Regards,

Prajna

1 Solution

Accepted Solutions
israrkhan
Specialist II
Specialist II

Here you go, Very simple...

Just use  this in Max 10000/1000 and K in Number Tab....

2013-11-05_174935.png

View solution in original post

8 Replies
israrkhan
Specialist II
Specialist II

where you want to display, in which control..

if you want to display in chart.. see the image below..

On Number tab, right >> down..

2013-11-05_171344.png

Not applicable
Author

hi,

I want to achieve in gauge chart...

Capture.PNG.png

I tried this it didn't work out

Regards,

Prajna

israrkhan
Specialist II
Specialist II

Use like below:

=Num(YourExpression / 100,'##.##K')

are you showing this in "Text in Chart" or ???

Not applicable
Author

hi,

Its nothing but min and max value in the gauge..

As shown in the above attached image.. wecan see some values rite? so that is the values given in as below

Capture.PNG.png

israrkhan
Specialist II
Specialist II

Hi,

On Number tab, set it fix to 0, and add K, see image

2013-11-05_174432.png

Result Below, But dont forget to Devide your Expression by 100

2013-11-05_174344.png

israrkhan
Specialist II
Specialist II

Here you go, Very simple...

Just use  this in Max 10000/1000 and K in Number Tab....

2013-11-05_174935.png

Not applicable
Author

Thank you

Regards,

Prajna

israrkhan
Specialist II
Specialist II

was very simple, but you did not explain it first, as you show image in last post.

any way...