Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
COUNT( DISTINCT INVOICEACCOUNT,&'-'&DELIVERYBRANCHID)
or
=Sum(Aggr( Count(Distinct DELIVERYBRANCHID),INVOICEACCOUNT,DELIVERYBRANCHID))
Feeling Qlikngry?
Try:
COUNT( DISTINCT INVOICEACCOUNT,&'-'&DELIVERYBRANCHID)
or
=Sum(Aggr( Count(Distinct DELIVERYBRANCHID),INVOICEACCOUNT,DELIVERYBRANCHID))
Feeling Qlikngry?
Thanks, second sentence works