Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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