Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi @QS21 ,
Did you have a date field in the dataset?
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..?
Hi @QS21 ,
Why do we have value for Dec21. As per my understanding, you will get the data of Dec21 in Jan22.
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 |
Hi @QS21 ,
Please find attached QVF.
Let me know if any doubt.
Hi @ Abhijitnalekar,
Apologies, but I am unable to view the file that you sent..
Thank you..
are you getting any error while opening the file?