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

Thank you for all suggestions.

1 Solution

Accepted Solutions
Highlighted
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

7 Replies
Highlighted
Not applicable

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

Can you load an example QVW ?

Highlighted
Not applicable

Highlighted
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

Highlighted
Not applicable

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

Thank you very much Andrew

Highlighted
Contributor

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

Hi, Can you please share qvf of the example ?

Thanks

Highlighted
Creator

Highlighted
Contributor

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

Hi,

Can you please share Qliksense sample app as well?

Thanks