previous year and current year data on a bar chart

[Anonymous]

I want to display the current and previous years data (by month) on a bar chart with the respective month columns side by side.

Below is some sample data I want to use,

Dimension = month , measures = DCIPU,

thanks in advance for your help

mfg_cat	MonthYear	Year	Month	MonthNbr	DCIPU
Ainsworth	20161	2016	January	1	1010
Ainsworth	20162	2016	February	2	1100
Ainsworth	20163	2016	March	3	1000
Ainsworth	20171	2017	January	1	1200
Ainsworth	20172	2017	February	2	1350
Ainsworth	20173	2017	March	3	1210

[sunny_talwar · Accepted solution]

May be this

Current Year

Sum({<Year = {"$(=Max(Year))"}>}DCIPU)

Previous Year

Sum({<Year = {"$(=Max(Year)-1)"}>}DCIPU)

[Anonymous]

That worked fine, thanks a lot Sunny

[sunny_talwar]

Not a problem. Please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny