topic Re: rank in text object in QlikView

rank in text object

Anonymous — Mon, 06 Nov 2017 08:00:01 GMT

hi there,

ı want to display top 3 values in a text objext of a dimension.

how can ı do this?

Re: rank in text object

prma7799 — Mon, 06 Nov 2017 08:14:11 GMT

Try this

aggr(if( rank(sum(Sale),4)<=3,State), State)

aggr(if( rank(sum(Sale))<=3,State), State)

aggr(if( rank((YourExpression))<=3,Dimension), Dimension)

Re: rank in text object

sergio0592 — Mon, 06 Nov 2017 08:18:07 GMT

Try with in text box :

='First :'&FirstSortedValue(Dimension, - Expression, 1) &Chr(10)&'Second:'&FirstSortedValue(Dimension, - Expression, 2) &Chr(10)&'Third:'&FirstSortedValue(Dimension, - Expression, 3)

Re: rank in text object

antoniotiman — Mon, 06 Nov 2017 08:37:41 GMT

May be like this

=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Money(Aggr(Sum(Value),Dimension)),Chr(10))

Re: rank in text object

Anil_Babu_Samineni — Mon, 06 Nov 2017 08:40:22 GMT

When you need text object?

=Concat({<[Ticket ID]={"=Rank(Sum(Sales), 4) <= 3"}>} Aggr(Sum(Sales),[Ticket ID]),Chr(10))

Re: rank in text object

antoniotiman — Mon, 06 Nov 2017 08:40:29 GMT

=Concat({<Dimension={"=Rank(Sum(Value)) <= 3"}>} Distinct Dimension,Chr(10))

Re: rank in text object

Anonymous — Mon, 06 Nov 2017 08:40:59 GMT

thanks for reply,

I have "term" dimension, and I wrote it like that;

=aggr(if( rank ( (sum(sales)-above(sum(sales),-1))/above(sum(sales),-1)) = 1,term), term)

it displays result but the wrong result. does not give the right rank=1 term

when I use the same formula

rank ( (sum(sales)-above(sum(sales),-1))/above(sum(sales),-1)) = 1

in a table, it gives different result.

Re: rank in text object

prma7799 — Mon, 06 Nov 2017 08:59:05 GMT

Please share some sample file with expected output.

Re: rank in text object

shraddha_g — Mon, 06 Nov 2017 09:13:04 GMT

concat({<term = {"=rank(sum(Sales)) <=3"}>} Distinct term, chr(10))