Last 14 day average from data set

[JanB]

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?

[squeakie_pig]

Check if the Date format has changed.  

[JanB]

Date in the raw data table I am pulling from is still showing as MM/DD/YYYY.