Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmpate0
Creator II
Creator II

match not working

Hi I'm trying to display a tab with selections for two users.


I have an on Open trigger on the document

=If(Match((Subfield(OSUser(),'\',2)='User1','User2' >0,'SH01','SH02'))) 


I want to add different selections for each user. Can I do this and have I got the syntax correct.


because when I open the document I can't see the correct sheet popping up on open.


Any help appreciated.


regards

M



10 Replies
qlikmpate0
Creator II
Creator II
Author

I don't really have user intervention on this as this would be only for display use only so i need it automated.