topic Values on Data Points in Thousands in QlikView

Values on Data Points in Thousands

Mon, 31 Oct 2011 14:59:33 GMT

Is it possible to display the Values on Data Points formatted in thousands??

I have formatted the Axis to show in thousands however cant get the Data Points. I have tried the Excel number format of

#,##0,

but that did not work.

Values on Data Points in Thousands

Mon, 31 Oct 2011 15:36:37 GMT

The quickest way is to devide your figures by 1000 like this

Sum({$<FiscalYear={$(=Max(total FiscalYear))}>}sales)/1000

Then use the number formatting in the number tab..

I hope this helps...

Values on Data Points in Thousands

Mon, 31 Oct 2011 15:39:24 GMT

Hi Razavial

Cheers for reply. I knew that was an option and yes that works for the visual representation but it then means any numbers extract to excel are incorrect and subject to misinterpretation.

I am looking to show the format whilst preserving the full detail.

Mark

Values on Data Points in Thousands

Mon, 31 Oct 2011 15:42:41 GMT

Ok I get you... I had this same issue... but worked around it by offering both data and a chart in the end..

Sorry.

Values on Data Points in Thousands

rrsrini2907 — Mon, 31 Oct 2011 16:15:08 GMT

Hi,

To have exactly the same type as requested, you can follow the below procedure.

Create a combo chart, have two expressions.

One with same metric and another with divided by 1000's and check value on data points for the second metric.

The display option for second metric should be none.

Regards,

Srini.

Values on Data Points in Thousands

Mon, 31 Oct 2011 16:28:37 GMT

Cheers, did the above and then converted it to a stacked bar chart and it does exactly what I was after

Thanks !!

Values on Data Points in Thousands

joefeyas — Tue, 27 Mar 2012 18:26:47 GMT

My axis changes from $B & $M & $K as filters are applied, so this solution will not work. Any suggestions?

ps.: Works on the stacked bar chart, I am using un-stacked bar chart and data points do not change with the axis.