Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

Pick (Match ) in dimension is invalid

I have a code like this " =Pick(Match(vstaff,1,2),[Staffing Group],[Mangers])", 

where vstaff is the variable input name and has two inputs to toggle between, dimensions should be displayed based on the variable input

1 Reply
Or
MVP
MVP

Your code won't return a dimension name, it will attempt to return the result of the field itself.

Try something along the lines of

$(=Pick(Match(vstaff,1,2), '[Staffing Group]', '[Mangers]')