conditional show/hide of object based on table value

[Qlik_Enthu]

hi all,

I have a requirement to show an object ( nothing but the image of batch completion status - green, yellow or red) based on the values of two fields from a table. the query will return the two columns. based on the combination values I have to show any one of the three objects.

how to achieve this?

TIA!

Regards,

Sai

[effinty2112]

Hi,

I suggest deleting two of the icons and make the image on the remaining conditional. Something like:

Pick(

Match(-1,

GetSelectedCount(ERRORCOUNT)=0 and GetFieldSelections(CODE_VAL_CHAR)='B',

GetSelectedCount(ERRORCOUNT)=0 or GetFieldSelections(CODE_VAL_CHAR)='B',

-1,),

'qmem://<bundled>/BuiltIn/check_g.png',

'qmem://<bundled>/BuiltIn/exclamation_y.png',

'qmem://<bundled>/BuiltIn/cross_r.png')

Good luck

Andrew