topic Re: Customer rank in QlikView

Customer rank

Fri, 11 Dec 2015 07:20:13 GMT

Hi All,

I have a Pivot table which is having Customer name and Rank among them for every source of sale, and their Total at the bottom.

Now I want a line chart with the total rank for each month for every Customer.

Ex: For Customer A the total sum of various sources rank is 22 and it has rank ""Two" among all the customers , this value I want to see as a line chart with Month as dimension how can I get it.

Can any one please help me .

Please find the attachment. for sample data

Best Regards

John

Re: Customer rank

tresB — Fri, 11 Dec 2015 07:30:51 GMT

Instead of HRank, try Rank(), like:

=Rank(sum(Sales)/sum(TOTAL Sales))

Re: Customer rank

MK_QSL — Fri, 11 Dec 2015 07:33:18 GMT

or may be

=Rank(sum(Sales))

Re: Customer rank

Fri, 11 Dec 2015 07:56:49 GMT

Hi Tresesco it's nice to here your words, I tried when I select the Month it is working fine, however if there is no selection the result is not showing correctly.

Re: Customer rank

tresB — Fri, 11 Dec 2015 08:19:02 GMT

If I select 'Jan', CustomerA's rank is 8; when no month is selected it is same I see. Could you tell where you find it incorrect?

Re: Customer rank

Fri, 11 Dec 2015 09:28:33 GMT

Thanks Tresesco , Please find the attachment there in the pivot table for Customer E we have rank as 1 , however in the line chart B has the rank one when no month has selected.

Re: Customer rank

tresB — Fri, 11 Dec 2015 09:32:30 GMT

Month-wise rank can always varry. Remove month from dimension, you would see Customer E is at rank 1.

Re: Customer rank

Anonymous — Fri, 11 Dec 2015 09:36:51 GMT

what about this?

=Rank(sum(Sales),4)

Re: Customer rank

Fri, 11 Dec 2015 09:54:28 GMT

No I can't I need to show it as Month wise rank for every Customer.