Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dandaanilreddy
Creator III
Creator III

Sum of value

Hello All,

I have categories which has values for each date. I need to sum up the total of category 1 category 2 and category 3 depending on the data range.

For example:

Category 3 has the starting date as 2019-07-09 and has a value 458. Now i want to pick the values from the category 1, 2 , 3 by considering the starting date of category 3. Here i need to pick the values of category 1 and 2 having the date range <= 2019-07-09. Please can someone let me know how to achieve this .

 

Category 1Category 2Category 2Category 3Category 3Category 3Category 4Category 4Category 4
2019-06-282019-07-012019-07-022019-07-092019-07-102019-07-112019-07-162019-07-172019-07-18
1214154588711284252329363349
   Total I need      
   499137026545136807211421

 

Thanks

Labels (1)
0 Replies