topic HOw to achieve first top values ?? in QlikView

HOw to achieve first top values ??

nikhilgarg — Mon, 12 Jan 2015 08:07:36 GMT

HEy,

How to get top 5 items according to sales wise(item with maximum sales at top and so on).

How to achieve this ?

Thanks

Re: HOw to achieve first top values ??

its_anandrjs — Mon, 12 Jan 2015 08:10:22 GMT

Hi,

For Top 5 use Rank function ad calculated dimension

Ex:_

Dim:- =If(Aggr(Rank(Sum(Sales)) <= 5, Customer),Customer)

Expr:- Sum(Sales)

Regards

Anand

Re: HOw to achieve first top values ??

maleksafa — Mon, 12 Jan 2015 08:11:00 GMT

if(rank(sum(Sales)) <= 5, sum(Sales))

Re: HOw to achieve first top values ??

its_anandrjs — Mon, 12 Jan 2015 08:14:34 GMT

Hi,

Check this example

Data:

LOAD * INLINE [
Item, Sales
A, 25698
B, 24823
C, 2624
D, 236645
E, 2365
F, 22666
G, 245598
H, 2258
I, 226336
J, 22689
K, 222223
L, 112121
M, 213215
N, 123121
];

In straight table chart

Dim:- =If(Aggr(Rank(Sum(Sales)) <= 5,Item),Item)

Expre:- Sum(Sales)

Regards

Anand

Re: HOw to achieve first top values ??

kiranmanoharrode — Mon, 12 Jan 2015 08:27:41 GMT

Hi Nikhil,

Go to chart Preperties -> Dimension Limits -> Select Item Field from List of Dimensions -> Check the Check Box (Restrict which values are displayed using the first expression) -> select radio box (Show Only) -> Select Largest from Drop down select -> enter 5 in input box

By above procedure you will get required output mentioned above...

Regards,

Kiran

Re: HOw to achieve first top values ??

Anonymous — Mon, 12 Jan 2015 08:45:19 GMT

Hi,

Try Calculated Dimension for displaying Top 5 records:

=aggr(If(RANK(aggr(sum(Sales), Customer)) <= 5, Customer) , Customer)

Goto Object Properties of Chart

Click "Dimension Limits"

Click "Restrict which values are displayed using the first expression"

Show only "Largest" 5 values and Click "OK"

Regards

Neetha

Re: HOw to achieve first top values ??

nikhilgarg — Mon, 12 Jan 2015 09:36:54 GMT

Hey,

What is the difference between your Calculated dimension and following calculated dimension ??

If(Aggr(Rank(Sum(Sales)) <= 5,Item),Item)

Re: HOw to achieve first top values ??

Anonymous — Mon, 12 Jan 2015 09:46:32 GMT

Hi,

There is no much difference between both the expressions,it's just i have grouped the sales amount based on dimension and calculated sum of sales to derive Top N Records.

Regards

Neetha