Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnpaul
Partner - Creator
Partner - Creator

Bar chart sorting to show year on year comparison

Hi,

I am attempting to show a bar chart with one year's invoices compared to the next year's. I would like to show this over a full twelve months.

This is best described in the attachment. What needs to be done is to keep Jan-09 next to Jan-10 rather than Jan-09, Feb-09 etc.

error loading image

Thanks for your help

2 Replies
Not applicable

Hi,

You can this if you sort by month and year;

SORT:

check expression, and put MONTH(date), Year(date)

Not applicable

Change your dimension, use just Month not Month-Year.

Create 2 expressions with set analysis, on for 2009 and one for 2010

sum({$<Year={'2009'}>} InvoicedAmount)

sum({$<Year={'2010'}>} InvoicedAmount)