Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Need to get particular records?

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.

12 Replies
Chanty4u
MVP
MVP

MK_QSL
MVP
MVP

Like this?

Change according to your need.

rathnam_qv
Creator
Creator
Author

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.

Chanty4u
MVP
MVP

chk attached  ratnam.

just chnge to manish dox.

rathnam_qv
Creator
Creator
Author

Hi Chanty,

sorry,...i don't have qlikview software installed in my machine...I am using Qlik sense

rathnam_qv
Creator
Creator
Author

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.

MK_QSL
MVP
MVP

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.

rathnam_qv
Creator
Creator
Author

Hi Manish,

can you please give me the expressions.

Chanty4u
MVP
MVP

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)