Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam4
Contributor
Contributor

Need to get fixed range sum in table chart measure expression

Hi Guys, I am new to qliksense. I need to find total SUCCESS count for each range of 'key' value to ('key' - 30) in qliksense tabular chart measure expression for the attached sheet data. For example, for key 516, I should get total success count as 27 since there are 27 success between 516 to 486(516-30). Similarly, 27 for 515 to 485 and so on ..... 
Please help.

 

Labels (1)
0 Replies