topic if field selected in QlikView

if field selected

Fri, 25 Oct 2013 14:27:54 GMT

Hello Together,

how can I write a textmessage in a textbox box depending on the figured selection ?

According to a psudocode:

if the "General Script Error" Value in the shown Field is selected,

then write "General Error occured" in an textbox,

else write "No Errors"

Thank you very much !

Best Regards,

Re: if field selected

javier_florian — Fri, 25 Oct 2013 14:31:17 GMT

Try with this:

=If(ERROR_TYPE_ETL_Process_3='General Script Error', "General Error occured","No Errors")

Re: if field selected

stevedark — Fri, 25 Oct 2013 14:38:20 GMT

You can achieve that using this code:

=if(index(GetFieldSelections(ERROR_Type_ETL_Process_3), 'General Script Error') > 0,

'General Error Occurred', 'No Errors')

That will highlight if that value is selected on its own or with others. You could just use this if you want it to be the only selection:

=if(GetFieldSelections(ERROR_Type_ETL_Process_3) = 'General Script Error',

'General Error Occurred', 'No Errors')

If you just want to know if it is a possible value, it would be this:

=if(maxstring({<ERROR_Type_ETL_Process_3*={'General Script Error'}>}ERROR_Type_ETL_Process_3) = 'General Script Error', 'General Error Occurred', 'No Errors')

Hopefully one of those options will give you what you require.

Steve