Count if / only qlik sense

[joeybird]

Hi

trying both ways , but wrong ..can I have some help please

I want to only ever count customers that only order on a specific month, and not on any other month of the year

e.g August

I have tried this way but don't work

Count(DISTINCT if([Month]='Aug', CustomerID))

I have heard you can do this with an only command

only({<[Month]={'Aug'}>} CustomerID)

but how do you count using an only?

please help

[swuehl]

The expression search will be affected by the selection state, so maybe

Count({<Department=, CustomerID = {"=Only({<Department=>} Month)= 'Aug' "} >} DISTINCT CustomerID)

[joeybird]

Hi

you cracked it

thank you Stefan / Team

Kind Regards