Dates

[QS21]

Hi All,

There was a requirement to automate some excel report using Qliksense.. Here , I read the data from excel files directly to qliksense.

In one of my logics   I use:  [MthYr] is my date variable

=IF(MthYr >= date(AddMonths(today(),-2),'YYYYMM')and MthYr <= date(AddMonths(today(),-1),'YYYYMM') , MthYr)

Example: today is 25-Sep-2021 , My report shows Aug data (All good)

Today is 2-Oct-2021, my logic gets refreshed and dtaa becomes zero .

I want to showcase only the last month data in my app. My data gets loaded everymonth between 11 to 15th..

Please help me modify the above logic so that it will not get refreshed automatically after 1st of everymonth..