Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some millions of records.
I want to create 3 pivot tales ...
1st table with top7 (1,2,3,4,5,6,7)suppliers (my dimension is Supplier)
2nd table with top8-14(8,9,10,11,12,13,14) Suppliers
3rd---top15-21(15,16,17,18,19,20,21) suppliers.
Can anyone help me out.
Thanks,
Muni.
hi,
use Rank function to get result.
=Aggr(If(Rank(Sum(Supplier))<7, field), Field)
Re: Top N in Pivot/Straight table with multiple dimension
How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table
Like this?
Change according to your need.
Hi Chanty,
Thank you for you valuable response,
with the above expression I will get Top7 records.
but how to get next records...like >7and<=14
>14 and<=21
Thanks,
Muni.
chk attached ratnam.
just chnge to manish dox.
Hi Chanty,
sorry,...i don't have qlikview software installed in my machine...I am using Qlik sense
Hi Manish,
Thank you for your reply.
I don't have Qlikview installed in my machine..m using Qlik sense.
I can't open the Qlikview file in qlik sense.
For 1st Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=7"}>}Sales)
For 2nd Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=14 and Rank(SUM(Sales),4)>7 "}>}Sales)
For 3rd Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=21 and Rank(SUM(Sales),4)>14 "}>}Sales)
Change Dimension and Expression as per your need.
Hi Manish,
can you please give me the expressions.
As manish.
For 1st Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=7"}>}Sales)
For 2nd Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=14 and Rank(SUM(Sales),4)>7 "}>}Sales)
For 3rd Pivot Table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Sales),4)<=21 and Rank(SUM(Sales),4)>14 "}>}Sales)