Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Or
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.
Create a variable, then use dimension limit and allow user to enter Top N Value to display for Sum(Sales).
See attached
Here you have an example
!
Top 5 analysis using Rank fuction
load you data and change the 5,10,20 etc in qvw as per your need
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
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
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
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
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.