Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

rathnam_qv
Contributor

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
sureshqv
Esteemed Contributor III

Re: Need to get particular records?

Re: Need to get particular records?

Like this?

Change according to your need.

rathnam_qv
Contributor

Re: Need to get particular records?

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.

sureshqv
Esteemed Contributor III

Re: Need to get particular records?

chk attached  ratnam.

just chnge to manish dox.

rathnam_qv
Contributor

Re: Need to get particular records?

Hi Chanty,

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

rathnam_qv
Contributor

Re: Need to get particular records?

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.

Re: Need to get particular records?

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
Contributor

Re: Need to get particular records?

Hi Manish,

can you please give me the expressions.

sureshqv
Esteemed Contributor III

Re: Need to get particular records?

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)