Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Adding Current year Max Month with previous year max month?


Hi Experts,

I want to add current year Max month value with previous year max month value(means 12th month).

for ex:

I selected financial year 2019-2020(Apr-May)

i want to add ---Mar-2019+currnt year Max month(May value)

How to pick the previous year Max Month value when i selected current year.

Note: I don't have the date field in the table, have only Month and Year like march'19, April'19.

Urgent plz help on this.


Labels (3)
2 Replies
Partner - Master III
Partner - Master III

First things first. create a date field with what you have e.g. March 19 becomes 1 March 19
You can use set analysis to achieve what you want.
Partner - Contributor III
Partner - Contributor III

Hi Dilip,
Thanks for quick response .
What will be my expression after creating calendar, what I have to mention in set analysis.