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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mangukiyam
Contributor
Contributor
‎2022-08-31 11:06 AM

Pick Match not working

=Pick(Match(vwaterfallDim, 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)

Labels (3)
Labels
Preview file
39 KB
761 Views
0 Likes
2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II
‎2022-08-31 11:33 AM

Hi,

 

If you try:

 

=Pick(Match('$(vwaterfallDim)', 'R1','C1','L1','C2')+1,
BUDesc,RegionDesc,CountryDesc,LocationIDDesc,GroundDesc)

 

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
754 Views
mangukiyam
Contributor
Contributor
‎2022-08-31 11:58 AM
Author

In response to Aurelien_Martinez

Thank you, It worked

 

746 Views
0 Likes