topic Top N Customers based on multiple conditions in QlikView

Top N Customers based on multiple conditions

Thu, 24 Feb 2011 06:40:45 GMT

Hi,

My requirement is as below.

I need to show the Top N customers based on below conditions.

§ Report should consider only customer where "Economic Capital >= 1 million USD".

§ Top N customer selection should be done on "Economic Capital Percentage", which is calculated based on the last month's EC and this month's EC.

Rest of the customers than top N, should be treated as "Others" and aggregated. They should also appear on the report

My report always shows 2 periods data. ANd in one of teh report, i am displaying Top N countries based on below condition on the dimension.

=if(aggr(rank(Sum({$<PeriodID = {$(=max(PeriodID))}>} BookValue)),Country)<=vCustNum,Country)

So in the similar way how to generate Top N customers for multiple condituons. Please suggest.

Thu, 24 Feb 2011 08:51:58 GMT

HI Mani,

Use

1. if(economic capital > 10000000 , Cutomers) ---------------- > dimension

2. make a Variable TOP and also use the same in input box at Front sheet.

3. Now got to chart properties > presentation and enter variable "TOP" in max number in chart.

4. Chart Properites > Sort ......do in decending order.

In this simple way too you can achieve you top Customers. N = variable enter in input box.

Please let me know if it works at u r end

Thu, 24 Feb 2011 10:21:42 GMT

here i have to consider 2 conditions for selecting the Top N customers.

1. Customers whose EC > 1000000 and

2. %EC change (Top N %EC change) -- here %EC change is current and Prev period %EC change.

Can we put these 2 conditions in a calculated diemnsion? If so, how to do?

Thu, 24 Feb 2011 13:10:14 GMT

Can you share your application... it will be easy for me to sort it out 🙂