problem with dynamic date logic

[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..

[abhijitnalekar]

Hi @QS21 ,

Did you have a date field in the dataset?

[QS21]

Yes, the data format is this way in the iput file:

Desc  Jan21  Feb21 ....... Dec21

ABC    1200     2100..........3250

The source team fills the data in new month cells every month...

In Qliksense, I do cross table and transpose the source file:

Desc  Date   Balance

ABC Jan21  1200

All I need is how can I display data form the latest month cells (that has values)

When I use max function it is picking obviously Dec21.. But dec will not have value unless it is Jan22

Is there any other way to pick the data from the month..?

[abhijitnalekar]

Hi @QS21 ,

Why do we have value for Dec21. As per my understanding, you will get the data of Dec21 in Jan22.

[QS21]

This is how the data looks like.. is there any pther way to pick the latest month (curr - 1) wihtout using "today"?

The above logic that I am using works absolutely fine. But after 1st of next month data goes blank untill new data is loaded..

Desc	1-Jan-21	1-Feb-21	1-Mar-21	1-Apr-21	1-May-21	1-Jun-21	1-Jul-21	1-Aug-21	1-Sep-21	1-Oct-21	1-Nov-21	1-Dec-21
ABC	24335	24312	324214	245435	3242143	324214	34213	234213	345324
DEF	457665	2313	4564	65467	234325	5454	435345	433245	435432

[abhijitnalekar]

Hi @QS21 ,

Please find attached QVF.

Let me know if any doubt. 

[QS21]

Hi @ Abhijitnalekar,

Apologies, but I am unable to view the file that you sent..

Thank you..

[abhijitnalekar]

are you getting any error while opening the file?