Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Apache
New Contributor III

Sum of Products based on date

Hi all...

I just need to know how to calculate (sum) the product based on the date of purchase...

Eg.Tv is 40000 and next tv is need to be 80000.... like this need to add by product by upcoming....

If u need more details find the PFA..

 

Thank You

Tags (3)
1 Solution

Accepted Solutions
Apache
New Contributor III

Re: Sum of Products based on date

Thanks To all...

I just Get the answer myself which is working for this...

=Aggr(RangeSum(Above(sum(Price),0,RowNo())),Product,Date)

 

Regards,

Apache

3 Replies
Employee
Employee

Re: Sum of Products based on date

Hello Apache,
Try this:
rangesum(above(sum(Price),0,aggr(rowno(),Product,Date)))
Apache
New Contributor III

Re: Sum of Products based on date

Hi David thank you.... I just tried your code.... but its not working.....

Apache
New Contributor III

Re: Sum of Products based on date

Thanks To all...

I just Get the answer myself which is working for this...

=Aggr(RangeSum(Above(sum(Price),0,RowNo())),Product,Date)

 

Regards,

Apache