topic Re: Count(Distinct) in QlikView

Count(Distinct)

npadilla73 — Fri, 16 Oct 2015 22:51:39 GMT

Hi Community,

I know it is a silly question, but I have no idea how to resolve this sintaxis with the function DISTINCT, I want DISTINCT two dimentions, after that, use COUNT expression, but when a try to use the next sentence,

= COUNT( DISTINCT (INVOICEACCOUNT, DELIVERYBRANCHID))

The system display an expression error.

Can anyone to help me .

Thanks

Re: Count(Distinct)

robert_mika — Fri, 16 Oct 2015 22:57:25 GMT

Try:

COUNT( DISTINCT INVOICEACCOUNT,&'-'&DELIVERYBRANCHID)

=Sum(Aggr( Count(Distinct DELIVERYBRANCHID),INVOICEACCOUNT,DELIVERYBRANCHID))

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Count(Distinct)

npadilla73 — Fri, 16 Oct 2015 23:24:13 GMT

Thanks, second sentence works