Month to date flag

[lessassy]

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

[lessassy]

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]

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]

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