Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
krish2459
Creator
Creator

pick(match)

Hi,

 

I'm trying to write below condition

pick(match(MvT, '711','712','713'),'711','712','713')

 

but I'm getting out as 

711 and 712

 

713 is missing.

Help me to get this.

 

Thanks..

Labels (1)
1 Solution

Accepted Solutions
nevilledhamsiri
Specialist
Specialist

Try This out,

pick(match(MvT, '711','712','713') +1,   'No', 'Yes') As mvt_flag

This way, Yes will carry the said numbers .

 

 

 

 

 

 

View solution in original post

2 Replies
nevilledhamsiri
Specialist
Specialist

Try This out,

pick(match(MvT, '711','712','713') +1,   'No', 'Yes') As mvt_flag

This way, Yes will carry the said numbers .

 

 

 

 

 

 

sunny_talwar

What exactly is the use of Pick Match here? MvT and the new field created will always be the same, right? because 711 is mapped to 711, 712 is mapped to 712 and 713 to 713