topic Re: Problem with formatting in KPI-object in QlikView

Problem with formatting in KPI-object

Wed, 16 Nov 2016 14:34:07 GMT

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 ?

kindly

Håkan

Re: Problem with formatting in KPI-object

sunny_talwar — Wed, 16 Nov 2016 15:00:19 GMT

May be using Num() function

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

Re: Problem with formatting in KPI-object

Wed, 16 Nov 2016 15:20:23 GMT

Then I get this:

Re: Problem with formatting in KPI-object

vishsaggi — Wed, 16 Nov 2016 15:22:56 GMT

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

Re: Problem with formatting in KPI-object

sunny_talwar — Wed, 16 Nov 2016 15:25:55 GMT

Try this:

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

Re: Problem with formatting in KPI-object

Wed, 16 Nov 2016 15:32:00 GMT

This is the result:

Re: Problem with formatting in KPI-object

sunny_talwar — Wed, 16 Nov 2016 15:33:52 GMT

There is a space between the last two single quotes.

Re: Problem with formatting in KPI-object

stabben23 — Wed, 16 Nov 2016 16:20:20 GMT

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

Re: Problem with formatting in KPI-object

Thu, 17 Nov 2016 09:02:46 GMT

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

Re: Problem with formatting in KPI-object

sunny_talwar — Thu, 17 Nov 2016 10:25:14 GMT

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

Re: Problem with formatting in KPI-object

Anonymous — Thu, 17 Nov 2016 12:50:29 GMT

This will work:

=num(3342394,'# ##0','.',' ')

second argument in red is single quote space single quote

Re: Problem with formatting in KPI-object

sunny_talwar — Thu, 17 Nov 2016 12:53:29 GMT

I did point that out to the OP, not sure if he has already tried this or not, but I agree that this should work

Re: Problem with formatting in KPI-object

Anonymous — Thu, 17 Nov 2016 12:56:25 GMT

Ah Yes, sorry sunny. I worked on this and got around to something else then hit post a while after without looking at the updates.

Re: Problem with formatting in KPI-object

sunny_talwar — Thu, 17 Nov 2016 12:58:41 GMT

You don't have to be sorry my friend. I was just trying to reiterate to the OP that this should have worked. Not holding you against posting

Re: Problem with formatting in KPI-object

Clever_Anjos — Thu, 17 Nov 2016 13:01:16 GMT

Please try this:

=replace(num(3231235,'#.##0'),'.', ' ')

Re: Problem with formatting in KPI-object

Thu, 17 Nov 2016 13:37:02 GMT

hello,

it works when you write the number direct, but when you have it in an variable it doesn´t

work.

Re: Problem with formatting in KPI-object

Anonymous — Thu, 17 Nov 2016 14:03:15 GMT

how is your variable being used?

$(vVariable) or just vVariable?

Re: Problem with formatting in KPI-object

Thu, 17 Nov 2016 14:18:22 GMT

Hello,

at last is it solved with '=num($(vG.KPI2),'# ##0','.',' ')'

Thank you all for your help.