Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Values on Data Points in Thousands

Hi

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.

1 Solution

Accepted Solutions
rrsrini2907
Creator
Creator

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.

View solution in original post

6 Replies
Not applicable
Author

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...

Not applicable
Author

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

Not applicable
Author

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

Sorry.

rrsrini2907
Creator
Creator

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.

View solution in original post

Not applicable
Author

Hi

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

Thanks !!

joefeyas
Contributor II
Contributor II

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.