Document Properties->Trigger->Select in Field for not including value

[praveenr035]

Hi,

I am to qlikview. I have a requirement not to include certain values in the Multibox filters when the report opens. For this, I have set up trigger in settings -> document properties->Trigger tab -> OnOpen (select in Field). It is not working, Can you please let me know how to do this?

Search string used = NOT 'Profile'

This is working fine when I need to include various values on report open, but not working when I use NOT, please help

Search string = '(*ABC*|DEF*)' This is working fine.

Thanks!

[m_woolf]

If you want 'Profile' to not appear in the multibox, try using an expression:

=if(MyField<>'Profile',MyField)

If you want 'Profile' to appear in the multibox, but not be selected:

first action: Select in field: 'Profile'

2nd action: Select Excluded

[praveenr035]

Thanks a lot! It worked.

If you want 'Profile' to appear in the multibox, but not be selected:

first action: Select in field: 'Profile'

2nd action: Select Excluded