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: 
Not applicable

Calculation Condition - Custom Error Message

Morning - I'm using calculated Condition to display a customer error message.  However, the custom message does not show consistently for all instances but only for one or two.....hoping it something simple....please let me know if I need to post additional information.

Thanks for the help!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try alt(sum([PVO 3rd Party USD]),0)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

Your calculation condition sum([PVO 3rd Party USD]) will return a number. Any number that isn't 0 will be evaluated as True. Only a 0 result will result in the Calculation condition unfulfilled message.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert - any quick ideas how to handle the null as well as the 0 in the same expression?

Gysbert_Wassenaar

Try alt(sum([PVO 3rd Party USD]),0)


talk is cheap, supply exceeds demand
prieper
Master II
Master II

sum(.....) >= 0

edit: typo

Peter