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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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]')