Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Need to get only one month data

Hi All,

I have a field called MonthYear starting from Jan 2014 to Sep 2017.

Now my problem is if i select any month in 2017 i need to get only Dec 2016 month data.

The same when i select any month in 2016 i need to get only Dec 2015 month data.


The same when i select any month in 2015 i need to get only Dec 2014 month data


Please let me know if you require anything more.


Attached app for more reference.


Thanks,

Bharat

12 Replies
bharatkishore
Creator III
Creator III
Author

Thanks a lot... Exactly what i needed thank you so much.

Can you tell me what is difference between Min and Max for the expression...

antoniotiman
Master III
Master III

Max() returns Max MonthYear (sep 2017) when no date is selected.

bharatkishore
Creator III
Creator III
Author

Thank you....