Show the % variance of dimension in a bar chart.

[#1]

Hello,

I would like to create a bar chart which will compare different category sales by selected MonthYear and show the % variance of MonthYear.

I created the bar chart, but I have no idea on showing the % variance of MonthYear like below.

Thank you for all suggestions.

[#2]

Can you load an example QVW ?

[#3]

I have already uploaded my QVW.

[awhitfield · Accepted solution]

Hi Eddie,

convert the chart to a combo and add the following second expression:

=sum(Quantity*UnitPrice)/above(sum(Quantity*UnitPrice))-sum(Quantity*UnitPrice)/(sum(Quantity*UnitPrice))

set this expression to Values on data points and you end up with something like this:

You may need to play with the options, sample app attached

REgards

Andy

[#5]

Thank you very much Andrew

[syedsaqib]

Hi, Can you please share qvf of the example ? 

Thanks

[syedsaqib]

Hi,

Can you please share Qliksense sample app as well?

Thanks