Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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