topic Re: Display in thousand in QlikView

Display in thousand

Tue, 31 May 2011 18:02:50 GMT

Hello community,

I'm trying to display the values in a bar chart in thousand (k) eg. 132.000 in 132k. Is there a simple option instead of dividing through thousand. Searched similar community postings without any working version for me. Also tried number formating etc. in chart options.

Thanks for your help. Kind Regards

Aloah

Display in thousand

nagaiank — Tue, 31 May 2011 18:15:17 GMT

In the Bar Chart properties, Number tab, add Thousand symbol, Million symbol, Billion symbol, etc.

Hope this helps.

Re: Display in thousand

Tue, 31 May 2011 18:53:38 GMT

Hi tried that, unfortunately still shows 132000 instead of 132k.

Display in thousand

prieper — Tue, 31 May 2011 19:35:45 GMT

If the display on the axis and the values on the datapoint shall be in the same dimension, think that you need to divide the results (in an expression) or the underlying values (in script) by 1Mio.

HTH
Peter

Re: Display in thousand

Wed, 01 Jun 2011 07:36:07 GMT

If u want ur data to appear like the attached sample...then refer the points below:

I hve also done the same as u said ...

First divided the value by 1000.in expression and then

In Number tab>>Number format Settings:Number>>Format Pattern:

Paste

##,###,###K here.

Hope ur problem is Solved.