topic Re: Top 20 Amount in QlikView

Top 20 Amount

sat_tok52 — Tue, 15 Mar 2016 13:02:55 GMT

Hi Guru's,

I want to display top 20 amount on text object ,Any help.

-Sateesh

Re: Top 20 Amount

sunny_talwar — Tue, 15 Mar 2016 13:05:59 GMT

In one text box or 20 text boxes?

Re: Top 20 Amount

sat_tok52 — Tue, 15 Mar 2016 13:09:10 GMT

Thanks Sunny.

In a single text object I want to show top 20 customers amount .

I wrote like this.

=SUM({<City = {"=Rank(SUM(Sales))<=20"}>}Sales)

-Sateesh

Re: Top 20 Amount

Saravanan_Desingh — Tue, 15 Mar 2016 13:10:13 GMT

One way to do..

=Concat({<Amount={"=Rank(Amount)<=20"}>}Amount,Chr(10))

Re: Top 20 Amount

MK_QSL — Tue, 15 Mar 2016 13:12:27 GMT

Your expression looks ok... What's wrong ?

Just replace City with Customer!

Re: Top 20 Amount

jyothish8807 — Tue, 15 Mar 2016 13:20:42 GMT

Hi Sateesh,

Try like this:

concat(SUM({<City = {"=Rank(SUM(Sales))<=20"}>}Sales),',')

Regards

Re: Top 20 Amount

brijesh1991 — Tue, 15 Mar 2016 13:25:07 GMT

Concate will work; Why don't you go with listbox and restrict top 20 by rank function and then remove caption and all... it will also give you a fleixibility to filter something!

Re: Top 20 Amount

MK_QSL — Tue, 15 Mar 2016 13:55:38 GMT

Use something like this in text box

=CONCAT(IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Aggr(Customer& ' : ' & CHR(9) & Num(SUM(Sales),'#,##0'),Customer)),CHR(10),-Aggr(SUM(Sales),Customer))

Re: Top 20 Amount

MK_QSL — Tue, 15 Mar 2016 13:59:47 GMT

=CONCAT(IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Aggr('Rank : ' & Rank(SUM(Sales),4) & CHR(9) & Customer& ' : ' & CHR(9) & Num(SUM(Sales),'#,##0'),Customer)),CHR(10),-Aggr(SUM(Sales),Customer))

This will give you top 5. You can change number accordingly to your need.