topic Re: Count Distinct clients by rank in QlikView

Count Distinct clients by rank

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

Hello,

I would like to get a count distinct customer based on the rank of the family, only where the rank= 1. The objective is to obtain a histogram counting the distinct clients according to the preferred family

thanks you

Re: Count Distinct clients by rank

Anil_Babu_Samineni — Mon, 12 Jun 2017 16:25:49 GMT

May be this?

Sum(If(Rank(Sum(FieldName))=1, Sum(FieldName)))

Re: Count Distinct clients by rank

sunny_talwar — Mon, 12 Jun 2017 16:47:50 GMT

Sum within Sum won't work without Aggr()... May be this

Sum(Aggr(If(Rank(Sum(FieldName))=1, Sum(FieldName)), CodeClient, super_famille))

Re: Count Distinct clients by rank

Sergey_Shuklin — Mon, 12 Jun 2017 17:25:50 GMT

Hello, Saoud!

I've generated some data with families. Please, look at the materials below, is this the task?

Re: Count Distinct clients by rank

Anonymous — Tue, 13 Jun 2017 12:41:03 GMT

Hello,

Thanks for your help but it's not exactly what i want because it count only one family but it is possible that a client like a different family : example number 000000003

thanks

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 06:35:43 GMT

Hello,

thank you for your reply, I tried your formula but it generates an error

regards

Re: Count Distinct clients by rank

Anil_Babu_Samineni — Wed, 14 Jun 2017 06:38:10 GMT

Can you show the expression in image?

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 06:55:25 GMT

Hello,

image of expression

thanks

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 06:57:59 GMT

Hello,

image of expression

thanks

Re: Count Distinct clients by rank

Anil_Babu_Samineni — Wed, 14 Jun 2017 07:05:35 GMT

There is no any typo error, What would be the issue. And that i've seen you image of data too. Seems working. What are you trying for right side report

Re: Count Distinct clients by rank

sunny_talwar — Wed, 14 Jun 2017 07:13:39 GMT

What sort of error does it display? can you share the error message or a snapshot of the error message?

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 07:15:30 GMT

On the right report I would like it also counts clients rank equal 1 on other families as the "KITCHEN"

regards

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 07:22:33 GMT

hello,

here is the error

thanks

Re: Count Distinct clients by rank

sunny_talwar — Wed, 14 Jun 2017 07:25:46 GMT

You are using this as a dimension? What is the final output you are looking to get? I thought that this was an expression....

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 07:33:58 GMT

no sorry

I am looking to get a discount from customers on preferred families

thanks

Re: Count Distinct clients by rank

Anil_Babu_Samineni — Wed, 14 Jun 2017 07:38:33 GMT

I assume, You require nested aggregation over here, Would it possible to share sample application

Re: Count Distinct clients by rank

sunny_talwar — Wed, 14 Jun 2017 07:39:03 GMT

What would be the output in a table form that you want to see? What are the dimensions?

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 08:33:36 GMT

here is table, I would like this report

thanks

Re: Count Distinct clients by rank

Anonymous — Wed, 14 Jun 2017 08:53:43 GMT

an example

Thanks

Re: Count Distinct clients by rank

Anil_Babu_Samineni — Wed, 14 Jun 2017 09:19:33 GMT

I opened your machine, You are calculating only for first rank, That is how it return only for that

And, i used this? and i got it as below

If(Rank(Sum(DISTINCT customer_code))<=4, Sum(DISTINCT customer_code))