IF condition is not working

[Joelle_AL-Hanna1]

Dears,

I am new at qliksense.

I want to add the client Count for all companies with the condition  to exclude a specific category for only Company X.

I use the formula=if (Company='X',count({$<TYPE={'Sales'}, Year=::Year, DateKey={"<=$(=Max(DateKey))"},Month= , MonthYear=,Day=,Quarter=,Week=,CLIENTCATEGORY_CODE-={'71'}>} Distinct CODE_CLI),count({$<TYPE={'Sales'}, Year=::Year, DateKey={"<=$(=Max(DateKey))"},Month= , MonthYear=,Day=,Quarter=,Week=>} Distinct CODE_CLI) )

I have the below table and the Count Client is displayed for only the current month. Can I know how to solve it 

Company	Month	Type	Count client
X	Jan	test	-
X	Jan	test2	-
X	Feb	test	-
X	Feb	test2	-
X	Mar	test	-
X	Apr	test	-
X	Apr	test2	-
X	May	test2	-
X	Jun	test	-
X	Jul	test	-
X	Aug	test	20
Y	Jan	test	-
Y	Jan	test2	-
Y	Feb	test	-
Y	Feb	test2	-
Y	Mar	test	-
Y	Apr	test	-
Y	Apr	test2	-
Y	May	test2	-
Y	Jun	test	-
Y	Jul	test	-
Y	Aug	test	-

[JHuis · Accepted solution]

Hello,

made an app for you to see the result. I excluded for company X the test2.

[Joelle_AL-Hanna1]

Thank you