Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Apache
Contributor III
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

1 Solution

Accepted Solutions
Apache
Contributor III
Contributor III
Author

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

View solution in original post

3 Replies
David_Capan
Employee
Employee

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

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

Apache
Contributor III
Contributor III
Author

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