Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
lessassy
Creator
Creator

Month to date flag

I have a master calendar and i would like to use a flag which use the max month of the max year of my database.

I don't want to comapre it to today() date but to my date fields within my data.

Basically my records end at february 2020 so the max month would be 02.

MTDFLG = 1 equals 02.

 

Thanks in advance for your help.

Besides i want the flag to be displayed at the opening of the report. But i don't want the lfag to be locked becauise i want to enable the regular users to select year and month field afterward.

 

Thanks

Labels (1)
3 Replies
lessassy
Creator
Creator
Author

Basically my master calendar generate dates until end of december. ANd that's the issue because based on my records with datas (maxdate) = 01/02/2020 whereas with master calendar date it's 01/12/2020

jfkinspari
Partner - Specialist
Partner - Specialist

I would suggest you find the max month in data using set expression referencing a field in the datamodel, that you know always i set to a value

e.g. Max({<Fieldname = {"*"]>}Date)

lessassy
Creator
Creator
Author

Thank you it worked !

By the way do you know how to activate a flag in qlik sense sheet without having it locked permanently.

By that i mean i have my flag: Dateflag = {'1'} as filter selected at the opening of the application.

But then i want to unflag it tyo use my other filters as well.

Thanks in advance