Sum aggr count distinct with a condition

[Qliksense_77]

Hi,

I want to count the number of distinct sales per day and per costumer, but only if it is a sale per telephone. 

Therefore I need to make this expression to be conditional of sale per telephone: 

Sum(Aggr(count (distinct sale), Date, costumer) )

[agigliotti · Accepted solution]

Hi @Qliksense_77 ,

Of course I don't know exactly your field names but you can try something as below:

=Sum( Aggr( count( {< sales_type = {'telephone'} >} distinct sale), Date, costumer ) )

I hope it can helps.
Best Regards

[Qliksense_77]

It works:)