Qlik Community

Ask a Question

App Development

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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