issue in IF statement in expr

[Qlik_Enthu]

Hi all,

This is my if statement condition--> =If((ORDER_STAT=11 OR ORDER_STAT=12),Num(Count(DISTINCT(ORDER_NUM))))

The expression has no errors. but my chart is not showing anything. Only this part is working: Num(Count(DISTINCT(ORDER_NUM)))

Could anyone help me identify what is that I am missing?

Thank you!

Regards,

Sai

[sunny_talwar · Accepted solution]

May be try this instead

Num(Count({<ORDER_STAT = {'11', '12'}>} DISTINCT ORDER_NUM))

[Qlik_Enthu]

Hi thanks much it worked