topic Re: Count (distinct ..) with 2 parameters in QlikView

Count (distinct ..) with 2 parameters

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

Hi Experts,

I came across an expression in which 2 parameters were passed in the Count(Distinct para1&para2) and I am not pretty sure whether i get it correctly or not, hence would like to hear from the experts on this.

Expression : =count({<[Type]={'Document'}>} DISTINCT ID&[DOC Name])

In the expression above Count (Distinct) is used with 2 parameters i.e. ID and NAME followed by a where condition of Type= "Document".

According to my understanding the above expression is counting number of Distinct ID of respective DOC Name followed by where condition.

Would like to hear from you whether my understanding is correct or not?

Thanks,

Punit

Re: Count (distinct ..) with 2 parameters

Anil_Babu_Samineni — Fri, 18 Nov 2016 04:55:06 GMT

Assume, If we have the same values from those two fields of concatenate it will work as you think.

But,

Load *, [DOC Name] & ID as Key Inline [

ID, DOC Name, Type

1, A, Document

2, B, Document

3, C, Document

1, A, Document1

];

=count({<[Type]={'Document'}>} DISTINCT Key)

Try this from your end on your personal edition.

Re: Count (distinct ..) with 2 parameters

tresB — Fri, 18 Nov 2016 04:55:48 GMT

It counts the Distinct combination of ID and NAME. You can assume of a composite key made of ID and NAME, and the expression gives the distinct count of the key followed by where clause (like you said).