How to get in between rank values?

[silambarasan]

Name	Value	Rank
Chandrashekar	23	1
priya	22	2
Acharya	21	3
Hareesh	20	4
Suprith	18	5
Rangaswamaiah	18	6
Rachagolla	17	7
BALAJI	17	8
Rajashekar	16	9
Lokesh	16	10

How to get in between rank values?

In a text object i want sum of Value for rank 4 to 8

[techvarun]

=Sum(if (Rank >=4 and Rank <=8,Value))

[tresesco · Accepted solution]

If you have Rank field available in data you can try like:

Sum({<Rank={'>3 <9'}>}Value)

Else,

Sum({<Name={"=Rank(Sum(Value))>3  and Rank(Sum(Value))<9"}>}Value)

[md_qlikview]

Hi,

Try below set expression

Sum({<Rank={'>3 <9'}>}Value)

[#5]

Have a look at this function in a text object

=Sum({<Name= {"=rank(Value,Name)<= 8"}>} Value )-Sum({<Name= {"=rank(Value,Name)<= 3"}>} Value )