topic Re: How to get in between rank values? in QlikView

How to get in between rank values?

silambarasan — Fri, 21 Jul 2017 09:44:10 GMT

How to get in between rank values?

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

techvarun — Fri, 21 Jul 2017 09:59:21 GMT

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

tresB — Fri, 21 Jul 2017 10:00:10 GMT

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 — Fri, 21 Jul 2017 10:09:57 GMT

Hi,

Try below set expression

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

Fri, 21 Jul 2017 10:19:45 GMT

Have a look at this function in a text object

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