topic Re: Display value in K's or Mil's in QlikView

Display value in K's or Mil's

Tue, 19 Nov 2013 14:45:47 GMT

Good morning,

I am having some difficulty displaying my values in thousands, millions, etc.

I have attached a picture...

All i'm trying to do, for my cases column, is display it in millions or thousands, but the boxes are greyed out. I am surprised i couldn't find this answer in the forums or the QV manual.

Thank you in advance,

-David

Re: Display value in K's or Mil's

bbi_mba_76 — Tue, 19 Nov 2013 15:53:27 GMT

Hi,

they are greyed, but you could change the format and set the format pattern or the separators?

Re: Display value in K's or Mil's

Tue, 19 Nov 2013 16:15:41 GMT

Hi,

You may arrange the million or thousand issue by dividing your field for example sum(cases)/1000 or sum(cases)/1000000. The actual formatting (comma. or decimal point as separator) can be done in the format pattern as showed by BBI_MBA_76.

Hope this helps.

Regards,

Gerrit

Re: Display value in K's or Mil's

stevedark — Tue, 19 Nov 2013 16:26:35 GMT

Hi David,

Those options are available to you when your chart is set to be a visual chart, but not when it is a straight table. Given the number of expressions I presume this is a table?

The Symbol fields are only really for the axis on charts, not for the display of values. Typically you would not want to have different granularity on different rows on a table.

If you know you always want to show millions (for example) you will want to divide your expression, for example:

sum(Amount) / 1000000

Typically when I am doing this I will declare a variable (to ensure I don't stuff up the number of zeros somewhere!):

sum(Amount) / v1M

To denote that the column is all shown in millions I would then add a 'M' to the Label of the expression.

If you needed to chop and change granularity on different rows you would need to build an if statement, to divide by the right amount and put the suffix on, but I would advise against that if you have the option.

Hope this helps.

Steve

Re: Display value in K's or Mil's

rbecher — Tue, 19 Nov 2013 17:37:32 GMT

Someone should create an idea about that. This should be a common format..

- Ralf