topic Re: Need to get particular records? in App Development

Need to get particular records?

rathnam_qv — Thu, 24 Mar 2016 09:47:27 GMT

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.

Re: Need to get particular records?

Chanty4u — Thu, 24 Mar 2016 09:53:50 GMT

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

Re: Need to get particular records?

MK_QSL — Thu, 24 Mar 2016 09:54:49 GMT

Like this?

Change according to your need.

Re: Need to get particular records?

rathnam_qv — Thu, 24 Mar 2016 10:11:07 GMT

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.

Re: Need to get particular records?

Chanty4u — Thu, 24 Mar 2016 10:35:10 GMT

chk attached ratnam.

just chnge to manish dox.

Re: Need to get particular records?

rathnam_qv — Thu, 24 Mar 2016 10:42:55 GMT

Hi Chanty,

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

Re: Need to get particular records?

rathnam_qv — Thu, 24 Mar 2016 10:44:55 GMT

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?

MK_QSL — Thu, 24 Mar 2016 10:45:42 GMT

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.

Re: Need to get particular records?

rathnam_qv — Thu, 24 Mar 2016 10:46:21 GMT

Hi Manish,

can you please give me the expressions.

Re: Need to get particular records?

Chanty4u — Thu, 24 Mar 2016 10:48:42 GMT

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)

Re: Need to get particular records?

rathnam_qv — Mon, 28 Mar 2016 11:54:35 GMT

Hi Manish,

SUM({<Customer = {"=Rank(SUM(Sales),4)<=14 and Rank(SUM(Sales),4)>7 "}>}Sales)

in the expression SUM(Sales),4)---what is 4 ?

can u please explain me?

Re: Need to get particular records?

rathnam_qv — Mon, 28 Mar 2016 13:57:25 GMT

ok Manish,...i got it.

Thanks you for ur help.

Re: Need to get particular records?

Chanty4u — Mon, 28 Mar 2016 14:06:11 GMT

coooooooool

if u got the correct answer Please close the thread by making correct and helpful answers above