topic Re: Top N Records in QlikView

Top N Records

Fri, 16 Jan 2015 03:26:44 GMT

Hi,

How to find out Top N Records, customerNo based on sum(Amounts).

I need to display in straight and pivot Table this sum(Amounts) must be in descending/Ascending order.

Could you please give the entire process and set expression.

Thanks,

MLNR

Thanks ,

MLNR

Please give your valuable answers to me

Thanks,

MLNR

Re: Top N Records

jagan — Fri, 16 Jan 2015 04:08:00 GMT

Hi,

Try like this

This can be achieved by using Dimension Limits (If you are using Qlikview 11)

Chart Properties -> Dimension Limits -> Select Restrict which values are displayed using the first Expression option->

Select Show Only -> Select Largest -> Give your N (number) -> Sort Tab -> Select Y Value or Numeric value -> Select Descending option

you can also do the same by using Calculating Dimension

Chart Properties -> Dimension -> Add Calculated Dimension -> Give your expression as

=Aggr(If(Rank(Sum(Sales), 1, 0) <= 10, Customer), Customer)

and select Supress When value is Null option.

Regards,

Jagan.

Re: Top N Records

jzimolong — Fri, 16 Jan 2015 04:17:31 GMT

Create a variable, then use dimension limit and allow user to enter Top N Value to display for Sum(Sales).

See attached

Re: Top N Records

ecolomer — Fri, 16 Jan 2015 05:17:23 GMT

Here you have an example

Re: Top N Records

SunilChauhan — Fri, 16 Jan 2015 05:43:44 GMT

Top 5 analysis using Rank fuction

load you data and change the 5,10,20 etc in qvw as per your need

Re: Top N Records

Mon, 19 Jan 2015 11:49:34 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that,

Thanks,

MLNR

Re: Top N Records

Mon, 19 Jan 2015 11:50:29 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that,

Thanks,

MLNR

Re: Top N Records

Mon, 19 Jan 2015 11:51:15 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that,

Tahnks,

MLNR

Re: Top N Records

Mon, 19 Jan 2015 11:51:48 GMT

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that,

Thanks,

MLNR

Re: Top N Records

jagan — Mon, 19 Jan 2015 13:45:23 GMT

Hi,

Create an InputBox and assign a variable to it and try expression below assume that variable is

vTopN

Chart Properties -> Dimension -> Add Calculated Dimension -> Give your expression as

=Aggr(If(Rank(Sum(Sales), 1, 0) <= vTopN, Customer), Customer)

OR specify dynamic value in Dimension Limits by using the variable

=vTopN

Hope this helps you.

Regards,

Jagan.