topic Measure - Rolling Date in App Development

Measure - Rolling Date

Anonymous — Tue, 21 Aug 2018 21:16:36 GMT

Any help with this expression:

SUM(aggr(IF(floor([completed_date.autoCalendar.Date])>=num(today())-30 and floor([completed_date.autoCalendar.Date])<= num(today()),[completed_date.autoCalendar.Date],null()), SUM(aggr(sum({$<order_type={'sales'}>}distinct quantity), order_product_id))))

Basically trying to apply a rolling date to a measure. See an error?

Re: Measure - Rolling Date

andrey_krylov — Wed, 22 Aug 2018 05:25:48 GMT

The expression does contain an error, but I still do not understand what you want to achieve

Re: Measure - Rolling Date

Anonymous — Wed, 22 Aug 2018 13:37:58 GMT

Trying to create a measure that will sum order sales if they fall within the last 30 days.

Re: Measure - Rolling Date

BalaBhaskar_Qlik — Wed, 22 Aug 2018 15:05:09 GMT

May be this:

=SUM(Aggr(Sum(Distinct {$<Order_type={'sales'}, [completed_date.autoCalendar.Date] = {">=$(=Date(max([completed_date.autoCalendar.Date])-30))"}>}Quantity), order_product_id))))

Re: Measure - Rolling Date

BalaBhaskar_Qlik — Wed, 22 Aug 2018 15:05:32 GMT

try this:

=SUM(Aggr(Sum(Distinct {$<Order_type={'sales'}, [completed_date.autoCalendar.Date] = {">=$(=Date(max([completed_date.autoCalendar.Date])-30, 'DD/MM/YYYY'))"}>}Quantity), order_product_id))))