How to calculate last n days run time in QlikView expression

[ashis]

Hi ,

I have straight table that have date field , location and the expression .

In the expression , I am having this below expression, if my todays run time is greater than last 10 days max run time then , show me the data .

Here is the expression

=if(aggr(max({<Date={"$(vEndDate)"}>}Query),Location)>
aggr(max({<Date={">=$(vStartDate) <=$(vEndDate)"}>}Query),Location),
aggr(max({<Date={"$(vEndDate)"}>}Query),Location))

vEndDate ==max(Date) ;

vStartDate = date($(=max(Date) -10),'DD/MM/YYYY') ;

when i run this expression separately without the if condition if works fine but inside if statement it is not working.

Please help.

[Brett_Bleess]

Best I have is the following Design Blog post that may provide some clues:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Here is the base URL for the area if you want to search further:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett