Date Range With AGGR Function

dineshm030 — Wed, 14 Jul 2021 17:39:25 GMT

Hi All,

I have created the Bar Chart with AGGR function with below expression.

Expression:

Sum(Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))

if I select ShiftDate = '07/07/2021', The date Should start from '28/06/2021' to '07/07/2021' and so on.

PFA...

Thanks in advance.

Regards,

Dinesh Kumar Mani.

Re: Date Range With AGGR Function

MayilVahanan — Thu, 15 Jul 2021 02:24:18 GMT

Try like below

Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))

o/p:

topic Re: Date Range With AGGR Function in QlikView

Date Range With AGGR Function

Re: Date Range With AGGR Function