topic Re: Top and Rank in QlikView

Top and Rank

Tue, 03 Jan 2017 06:45:55 GMT

I have 2 questions.

Firs: Maybe do you know how through button I can to select in filter (list) thise products ( top 4)

But I don't understand why I see 3 products, if my exspression - Product = {"=Rank(Sum(volumn))<=4"}

and

Second

How Qv selects which display in top product, if they are of equal value

Re: Top and Rank

stabben23 — Tue, 03 Jan 2017 07:30:27 GMT

Hi,

if you add rank in Your straight table you see that you have 3 Product that is <=4.

If they have the same value, qlikview wont know who to display, both will be visible.

Re: Top and Rank

pathiqvd — Tue, 03 Jan 2017 07:40:29 GMT

Hi,

If you want to show top 3 products volumn. don't use rank function in expressions use in add calculated dim, try below this

Add calculated dim:- =if(aggr(rank(sum(volumn)),product)<=3,product)

exp:- sum(volumn)

regards,

Re: Top and Rank

Tue, 03 Jan 2017 07:43:51 GMT

I want, if I click on the button "Rank", in list i see product like to text object ( first questions)

Re: Top and Rank

petter — Tue, 03 Jan 2017 07:44:38 GMT

Rank() function can take two additional parameters: mode and fmt

The documentation explains the additional parameters and how they affect the ranking:

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/RankingFunctions/rank.htm

In your textbox you will have to use this expression to get all four top ranking products:

=Concat(DISTINCT {<Product = {"=Rank(Sum(volumn),4)<=4"}>} Product, ' | ')

Notice the added second parameter to Rank in this expression. Mode=4 which means that every ranked product should get a unique ranking even if two or more products rank equally. With you Rank with no additonal parameters you will get a numeric ranking of 1 to 3 for each product and the rest of the products are ranked from 5 and upwards - it leaves a missing rank of 4 since two products are ranked as 1.

For your second question - you can by using the additional mode parameter to choose whether you will have the same ranking value for two or more products that have equal ranking or if they should have unique rankings even if they are equal. They will then be ranked according to sort order in your chart.

Notice also that Rank returns dual values - both a text and a number.

I have attached a modified QlikView app to illustrate a little bit:

Re: Top and Rank

petter — Tue, 03 Jan 2017 07:48:00 GMT

I updated you sample application to work with a button too - see attached QVW...

Re: Top and Rank

pathiqvd — Tue, 03 Jan 2017 07:51:09 GMT

Hi,

Try this in text object

create one variable like vBT after create button and write below condition in ext object

=if(vBT=0,concat(if(aggr(rank(sum(volumn)),product)<=3,product),'|'))

Regards,

Re: Top and Rank

Tue, 03 Jan 2017 08:04:30 GMT

thanks, but I want

button effect on the list

Re: Top and Rank

petter — Tue, 03 Jan 2017 08:24:14 GMT

Then this should do the trick: