Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Show the % variance of dimension in a bar chart.

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.

sales bar chart.png

Thank you for all suggestions.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Show the % variance of dimension in a bar chart.

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

View solution in original post

7 Replies
Highlighted
Not applicable

Re: Show the % variance of dimension in a bar chart.

Can you load an example QVW ?

Highlighted
Not applicable

Re: Show the % variance of dimension in a bar chart.

I have already uploaded my QVW.

Highlighted
Partner
Partner

Re: Show the % variance of dimension in a bar chart.

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

View solution in original post

Highlighted
Not applicable

Re: Show the % variance of dimension in a bar chart.

Thank you very much Andrew

Highlighted
Contributor
Contributor

Re: Show the % variance of dimension in a bar chart.

Hi, Can you please share qvf of the example ? 

Thanks

Highlighted
Creator
Creator

Re: Show the % variance of dimension in a bar chart.

 
Highlighted
Contributor
Contributor

Re: Show the % variance of dimension in a bar chart.

Hi,

Can you please share Qliksense sample app as well?

Thanks