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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with formatting in KPI-object

Hello,

how shall I do to get the value 3342394 formatted in the KPI-object  in the same

way as it is in the variable vG.KPI1 ?

sshot-1.png

sshot-2.png

kindly

Håkan

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

how is your variable being used?

$(vVariable) or just vVariable?

View solution in original post

17 Replies
sunny_talwar

May be using Num() function

=Num(vG.KPI1, '# ###')

Not applicable
Author

Then I get this:

sshot-3.png

vishsaggi
Champion III
Champion III

Is it possible to share your sample app to look into?

sunny_talwar

Try this:

=Num(3231235, ' # ### ###', '.', ' ')

Not applicable
Author

This is the result:

sshot-4.png

sshot-5.png

sunny_talwar

There is a space between the last two single quotes.

Capture.PNG

stabben23
Partner - Master
Partner - Master

try this one num(3231235,'# ##0',',')

Not applicable
Author

Hello all,

I have tested the different suggestions but it doesn´t work. I have also tested to change the format for

number on the pc but still the same result. The strange thing is that it works in the calculation  but not

when showing the result in the KPI-object so it looks that the formatting for text in the chart doesn´t work.

kindly

Håkan

sunny_talwar

I am not sure what issue you are running into, but it seems to be working well here:

Capture.PNG