topic How to get Rank based on Customer Name? in QlikView

How to get Rank based on Customer Name?

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using the below rank() function in my expression:

aggr(rank(sum({<FlagYTD={'YTD'}>}Sales)),[Customer Name]), but it does not work for me and gives only '-'.

I have attached my QVW file. Please help me.

Re: How to get Rank based on Customer Name?

prma7799 — Thu, 01 Jun 2017 11:21:45 GMT

where is the attachment

Re: How to get Rank based on Customer Name?

tresB — Thu, 01 Jun 2017 11:37:37 GMT

What is your expected output? If you are looking output in the chart, might try using NODISTINCT like:

aggr(NODISTINCT rank(sum({<FlagYTD={'YTD'}>}Sales)),[Customer Name])

Re: How to get Rank based on Customer Name?

sunny_talwar — Thu, 01 Jun 2017 11:49:06 GMT

I don't see the use of the above expression in the attached qvw file?

Re: How to get Rank based on Customer Name?

ananyaghosh — Thu, 01 Jun 2017 11:56:22 GMT

Hi,

I have re-upload it. Please can you check?

Re: How to get Rank based on Customer Name?

sunny_talwar — Thu, 01 Jun 2017 11:58:13 GMT

Did tresesco‌'s suggestion not work for you? What is the expected output for the Cus Rnk column?

Re: How to get Rank based on Customer Name?

ananyaghosh — Thu, 01 Jun 2017 12:09:46 GMT

Hi,

If you look at the first straight table with title 'Calculations - MTD,YTD,Current Sale' , then you can see that the column value for 'Customer YTD Rank ' has only 1 instead of showing rank. I don't understand what is the reason for it.

So if t has some reason please can u tell me what I have done wrong there?

Re: How to get Rank based on Customer Name?

sunny_talwar — Thu, 01 Jun 2017 12:21:19 GMT

You mentioned what you don't want to see, but I still don't know what you do want to see

Re: How to get Rank based on Customer Name?

ananyaghosh — Thu, 01 Jun 2017 13:38:11 GMT

Hi,

Please check my attached QVW file.

So if t has some reason please can u tell me what I have done wrong there?

Thanks,

Sandip