topic sort in QlikView

sort

parvez933 — Fri, 30 Nov 2018 09:16:41 GMT

Hello Everyone!

Please help me with the below scenario

load * inline [
Products, Sales
P1, 123
P2, 234
P3, 345
P4, 456
P5, 567
P6, 678
P7, 789
P8, 891
P9, 911
P10, 124
];

Question:
With in a straight table, display the products whose rank(sales) ranges between 3 to 7 by using
1. Set Analysis with p()
2. By using the rank() in the if loop or other

Note:
The products should be from rank3 to rank7 in descending order.

I tried with the rownum() in the if loop, it is returning as per the rownum but not by the rank of sum. Any suggestions please.

Re: sort

Frank_Hartmann — Fri, 30 Nov 2018 09:25:19 GMT

StraightTable:

Dimension:

=if(aggr(rank(Sales),Products)>=3 and aggr(rank(Sales),Products)<=7,Products)

Expression:

sum(Sales)

and sort sum(Sales) in ascending order!

Re: sort

tresB — Fri, 30 Nov 2018 09:37:49 GMT

I would do it like I showed at: your other post

Re: sort

parvez933 — Fri, 30 Nov 2018 09:58:33 GMT

Hey Frank!

I tried the way you suggested, but in the straight table I dint know why an extra row is showing in the bottom

Please help me!

Re: sort

Frank_Hartmann — Fri, 30 Nov 2018 10:01:54 GMT

You will need to supress Null Values for your dimension

Re: sort

parvez933 — Fri, 30 Nov 2018 10:12:03 GMT

Hey Frank!
Thank you for your response. The case is solved. But I have a small query! what is the difference of using rank(sales) to rank(sum(sale)) in the above scenario.

Re: sort

Frank_Hartmann — Fri, 30 Nov 2018 10:17:12 GMT

in your case using sum(Sales) will give you the extra value of 2283 for the Null values in your dimension. If you just use Sales you wont get the 2283. So i would prefer to always use sum(Sales) instead of just Sales

Re: sort

parvez933 — Fri, 30 Nov 2018 10:20:02 GMT

Thank You Frank! It got resolved.