Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_Enthu
Creator II
Creator II

issue in IF statement in expr

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this instead

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

View solution in original post

2 Replies
sunny_talwar

May be try this instead

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

Qlik_Enthu
Creator II
Creator II
Author

Hi thanks much it worked