Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlik Sense and have developed a dashboard that has worked well. On Monday the dashboard broke after IT upgraded to the new release Qlik Sense February 2020.
I have a run chart and I am displaying only the last 14 days of data. Dimension is Date and Measure is FulFilledDoses. The whole table has a year worth of information but I only show the last 14 days by including the following expression
Dimension:
=if(DispenseDate >= today()-14 and DispenseDate< today(), DispenseDate)
Measure:
=if(DispenseDate >= today()-14 and DispenseDate< today(),Sum(FulfilledDoses))
which is working great.
Now I have a KPI value for the FulfilledDoses and I need to create an average for the last 14 days and I use the following expression
=avg({$<Date={">$(=Date(Max(Date)-14))<=$(=Max(Date))"}>}FulfilledDoses)
This has worked great until the IT update. Now the value that is calculated is for the whole data set and it ignores the last 14 days I am trying to show.
Any suggestions on what is going on?
Check if the Date format has changed.
Date in the raw data table I am pulling from is still showing as MM/DD/YYYY.