Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rozgonyi
Partner - Contributor II
Partner - Contributor II

Sum of one dimension with ranking mode 4.1

Hello everyone,

I need your support with the following
I have a ranking with function 4,1 and I only want to add up the values that have the smaller ranking number than 5. In my example I got the ranking number 4 is also correct for me because they have the same values. But I don't get along with the If formula or Setexpression. The rank function should also take into account the result with mod 4.1.

Can someone please help me?

Rozgonyi_0-1711451028321.png

 

Labels (1)
0 Replies