topic Re: Straight Table - Top N Customers' Profit in QlikView

Straight Table - Top N Customers' Profit

Mon, 13 Apr 2015 15:18:11 GMT

Hello There!

In a Straight Table, I've selected Restriction 'Show Only Largest N Values' and also 'Show Others' check-box.

Now, when I'm looking at Top 20 Customers' Profit where 'CustomerName' is a Dimension and 'Profit' is an Expression, and the Data appears as below (which is correct):-

CustomerName	Profit
Customer01	26.91
Customer02	25.65
Customer03	15.29
Customer04	7.21
Customer05	5.89
Customer06	5.78
Customer07	5.77
Customer08	5.18
Customer09	4.90
Customer10	4.48
Customer11	4.32
Customer12	4.32
Customer13	4.22
Customer14	4.10
Customer15	3.98
Customer16	3.76
Customer17	3.72
Customer18	3.59
Customer19	3.52
Customer20	3.44
Only Others:	176.22

However, when I enable another Expression named 'Sales' the list appears for (say) 15 Top Customers as below:-

CustomerName	Sales	Profit
Customer01	105.61	26.91
Customer02	126.86	25.65
Customer03	119.71	15.29
Customer04	35.89	7.21
Customer05	54.81	5.89
Customer06	27.88	5.78
Customer07	19.03	5.77
Customer08	25.74	5.18
Customer11	22.51	4.32
Customer12	34.03	4.32
Customer13	33.75	4.22
Customer14	26.14	4.10
Customer16	30.04	3.76
Customer18	28.68	3.59
Customer32	22.00	1.35
Only Others:	1,143.41	198.91

The Customers are not listed as per the correct Order as highlighted Red in the above. Can anyone help me to sort-out this problem so that having additional Expression, I can get the correct Customer list (Top 10/15/20....N) as per Descending order of Profit?

Appreciate your prompt response and solution.

Thanks in Advance.

Sajjad.

Re: Straight Table - Top N Customers' Profit

Mon, 13 Apr 2015 15:31:51 GMT

Hi Sajjad,

dimension limits is based on the first expression in your chart, so move your 'profit' expression to be first if that is the one you want to limit on

Hope that helps

Joe

Re: Straight Table - Top N Customers' Profit

ramoncova06 — Mon, 13 Apr 2015 15:37:36 GMT

have you tried promoting the profit sort order ? in the sort section ?

Re: Straight Table - Top N Customers' Profit

Mon, 13 Apr 2015 15:39:01 GMT

Or if you need the order to be 'sales' and then 'profit', keep these but create 'profit' again as a hidden expression in the first position (can hide in the presentation tab).

Re: Straight Table - Top N Customers' Profit

Mon, 13 Apr 2015 15:41:06 GMT

Hi,

Straight Table Select Top dimension based on the value of first expression.... So Accordingly you can promote and demote the expression by which you want select the Top 15 cusstomer

Regards,

Vivek

Re: Straight Table - Top N Customers' Profit

SunilChauhan — Mon, 13 Apr 2015 15:54:00 GMT

go ot properties-> sort -> Y-value-> select decending( after

hope this helpslecting expression you want to sort /display on)

hope this helps