Qlik Altering wiht dynamic filter on date

[Federico_Rizzello]

Hi to all,

I'm trying to create an alert which triggers daily with the list of all order numbers that where issued on the previous day. Basically, every morning I want to get an alert with orders issued the day before.

My field are: "Order Number", "Order Date", "Order Value"

I created 2 master dimensions for "Order Number" and "Order Date", a master measure "Total Value" with "sum(Order Value)".

The problem is that in the alert I have to use the "Order Date" as a measure to be able to use it in the condition. My condition is: "Order Date"=date(Today(1)-1)) (see screenshot). What am I doing wrong? is there a better solution?

Thanks for your suggestions. Best regards.

FR

[MarcinS]

Hi.

You can create a dimension on the calendar for example:

If (num (weekday (today ())) = 0, if (date (TempDate, 'YYYY-MM-DD') = date (today () - 3, 'YYYY-MM- DD '), 1,0), if (date (TempDate,' YYYY-MM-DD ') = date (today () - 1,' YYYY-MM-DD '), 1,0)) as IsLastBD
...and use it in Qlik Alerting.

Of course TempDate is your main date.

M