Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variance in a Bar Chart

Hi,

I'm trying to create a combo chart which shows the % annual growth of sales (like the blue line in the image).

The values on data points aren't that important, my question is how can I make this line.

I tryed use set analysis with current year - current year-1 but doesn't worked.

My idea is to use a Dimension Group with Year and Month to show the variance when the user interact with the chart.

annualGrowth.png

1 Solution

Accepted Solutions
Not applicable
Author

Use:

=sum(Sales)/above(sum(Sales))-1

View solution in original post

2 Replies
Not applicable
Author

Hi,

Try with this:

(sum(Field) - Above(sum(Field))) / Above(Sum(Field))

Above() function gets the previous value.

Regards,

Ricardo

Not applicable
Author

Use:

=sum(Sales)/above(sum(Sales))-1