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: 
abc_18
Creator II
Creator II

how to write 'Pick Match' to replace IF with multiple parameters

I have below two expressions from two different tables, now I need to merge these conditions in one and display in one table.

how to write Pick(Match ())function to replace IF and merge these two ? Not sure how to use multiple parameters here. Below are the expressions -

=if(OStype='Windows 10/11'and (date=vCurrentDate or date=vLast7Day) ,buildnumber&'-'&version)

=if(OStype='Non-Windows 10/11' and (date=vCurrentDate or date=vLast7Day )  ,OS system)

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

=if(date=vCurrentDate or date=vLast7Day

,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),

buildnumber&'-'&version , [OS system] )  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

=if(date=vCurrentDate or date=vLast7Day

,pick(wildmatch(OStype,'Windows 10/11','Non-Windows 10/11'),

buildnumber&'-'&version , [OS system] )  )

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
abc_18
Creator II
Creator II
Author

Thanks Vineeth, it's working