Skip to main content

New to Qlik Sense

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DS14
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.

Thanks,

Labels (3)
2 Replies
dplr-rn
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.
DS14
Partner - Contributor III
Partner - Contributor III
Author

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