topic Re: Calculation Condition - Custom Error Message in QlikView https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821201#M533067 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert - any quick ideas how to handle the null as well as the 0 in the same expression?</P></BODY></HTML> Mon, 30 Mar 2015 16:50:09 GMT 2015-03-30T16:50:09Z Calculation Condition - Custom Error Message https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821199#M533065 <HTML><HEAD></HEAD><BODY><P>Morning - I'm using calculated Condition to display a customer error message.&nbsp; 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.</P><P></P><P>Thanks for the help!</P><P></P><P> <IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82389_pastedImage_5.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 30 Mar 2015 16:28:31 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821199#M533065 2015-03-30T16:28:31Z Re: Calculation Condition - Custom Error Message https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821200#M533066 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 30 Mar 2015 16:47:58 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821200#M533066 Gysbert_Wassenaar 2015-03-30T16:47:58Z Re: Calculation Condition - Custom Error Message https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821201#M533067 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert - any quick ideas how to handle the null as well as the 0 in the same expression?</P></BODY></HTML> Mon, 30 Mar 2015 16:50:09 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821201#M533067 2015-03-30T16:50:09Z Re: Calculation Condition - Custom Error Message https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821202#M533068 <HTML><HEAD></HEAD><BODY><P>Try alt(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum([PVO 3rd Party USD])</SPAN>,0)</P></BODY></HTML> Mon, 30 Mar 2015 16:54:46 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821202#M533068 Gysbert_Wassenaar 2015-03-30T16:54:46Z Re: Calculation Condition - Custom Error Message https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821203#M533070 <HTML><HEAD></HEAD><BODY><P>sum(.....) &gt;= 0</P><P></P><P>edit: typo</P><P>Peter</P></BODY></HTML> Mon, 30 Mar 2015 16:55:06 GMT https://community.qlik.com/t5/QlikView/Calculation-Condition-Custom-Error-Message/m-p/821203#M533070 prieper 2015-03-30T16:55:06Z