Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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!

Tags (2)
1 Solution

Accepted Solutions

Re: Calculation Condition - Custom Error Message

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


talk is cheap, supply exceeds demand
4 Replies

Re: Calculation Condition - Custom Error Message

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

Re: Calculation Condition - Custom Error Message

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

Re: Calculation Condition - Custom Error Message

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


talk is cheap, supply exceeds demand
prieper
Honored Contributor II

Re: Calculation Condition - Custom Error Message

sum(.....) >= 0

edit: typo

Peter

Community Browser