Count(Distinct)

[npadilla73]

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

[robert_mika · Accepted solution]

Try:

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

or

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

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[npadilla73]

Thanks, second sentence works