Msgbox

Thu, 12 Aug 2010 14:00:27 GMT

Hi ,

Is it possible to use the Msgbox function in the expression in Straight or Piviot table.

for ex:

=if(a< b, sum(CID),Msgbox("A should be less than b"))

Regards,XXX

Msgbox

Thu, 12 Aug 2010 14:11:58 GMT

Instead of using a message box, you can use the calculation condition to highlight the required text when the calculation condition is not satisfied. Use the below expression in the 'Calculation Condition' property under the 'General' tab

=if(a< b, true(),false())

The required error message can be entered by using the 'Error Messages' button in the 'General' tab.

topic Msgbox in QlikView

Msgbox

Msgbox