Sum of quantity where cdate >= d7

[engishfaque]

Dear All,

I would like to calculate sum of quantity where cdate >= d7.

I'm going to achieve my required result through following script and expression in Qlik Sense, but given below expression is returning Zero "0" value.

Please make correction, and share me expression.

My script:

temp:

Load

     date(Max([date/time])-6) as d7

Resident sales2015 Group By [date/time];

My expression:

sum({<cdate = {'>=[d7]'}>} quantity)

Kind regards,

Ishfaque Ahmed

[engishfaque · Accepted solution]

Dear All,

Problem has been resolved, here are the expressions.

1D = Sum({$<[cdate] = {">=$(=Date(Max([date/time]),'DD-MM-YY'))"}>} [quantity])

7D = Sum({$<[cdate] = {">=$(=Date(Max([date/time])-6,'DD-MM-YY'))"}>} [quantity])

15D = Sum({$<[cdate] = {">=$(=Date(Max([date/time])-15,'DD-MM-YY'))"}>} [quantity])

30D = Sum({$<[cdate] = {">=$(=Date(Max([date/time])-30,'DD-MM-YY'))"}>} [quantity])

Another thread is here,

Sum of Quantitiy - Expression

Kind regards,

Ishfaque Ahmed