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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I use Set Analysis in a bar chart to compare monthly EBIT with EBIT the same month previous year?

Hi,

I am trying to make a bar chart that for each month shows that month's EBIT, the budgeted EBIT plus EBIT of the same month a year ago (i.e. 3 bars side-by-side for each month). Right now I am trying to do this with set analysis, using an expression similar to:

sum( {$<Year = {$(=Only(Year)-1)}>} EBIT )

The product is this:

Bar chart.jpg

Is there some way I can show the "EBIT Previous year" bars side-by-side with the EBIT and budget bars, i.e. making them appear at 201302/201303 instead of 201202/201203 respectively in his example? If not, how can I solve this otherwise?

Many thanks in advance!

0 Replies