topic Re: Results for top selling customer only in QlikView

Results for top selling customer only

NickBentley — Tue, 12 Jan 2021 00:06:17 GMT

Hi All,

I am after some advice on how to show the name and sales for the top selling customer only in a straight table.

As shown in the example below, I am trying to find the correct expression to be applied.

Thanks in advance!

Product	Total Sales	Top Selling Customer Name	Top Selling Customer Sales
A	$7,140,094
B	$534,855
C	$3,830,149
D	$2,178,790
E	$427,070
F	$1,431,438
G	$369,771
H	$411,258
I	$274,445
J	$112,001
K	$72,054

Re: Results for top selling customer only

Saravanan_Desingh — Tue, 12 Jan 2021 01:43:46 GMT

Something like this?

tab1: LOAD * INLINE [ Product, Total Sales , Top Selling Customer Name, Top Selling Customer Sales A, "$7,140,094", , B, "$534,855", , C, "$3,830,149", , D, "$2,178,790", , E, "$427,070", , F, "$1,431,438", , G, "$369,771", , H, "$411,258", , I , "$274,445", , J, "$112,001", , K, "$72,054", ];

Re: Results for top selling customer only

Saravanan_Desingh — Tue, 12 Jan 2021 01:45:28 GMT

Top Selling Customer Name

=FirstSortedValue(Product,-[Total Sales])

Top Selling Customer Sales

=FirstSortedValue([Total Sales],-[Total Sales])

Re: Results for top selling customer only

NickBentley — Wed, 13 Jan 2021 01:56:07 GMT

Thanks saran7de!

I managed to use the FirstSortedValue expression and it worked a treat, thanks once again!