Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be this
Current Year
Sum({<Year = {"$(=Max(Year))"}>}DCIPU)
Previous Year
Sum({<Year = {"$(=Max(Year)-1)"}>}DCIPU)
May be this
Current Year
Sum({<Year = {"$(=Max(Year))"}>}DCIPU)
Previous Year
Sum({<Year = {"$(=Max(Year)-1)"}>}DCIPU)
That worked fine, thanks a lot Sunny
Not a problem. Please close the thread by marking the correct response.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny