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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
juliakhaa
Creator
Creator

How to write a mask to output a set of values

Hello everyone, is it possible to write something like a mask in case or some other way?

case when id_code in (
'8.2.28.',
'7.2.28.',
'24.2.28'
)
then 'documentation_expertise'

Trying this method or with like, but something is not right)

case when id_code in (
'*.2.28.')
then 'documentation_expertise'

5 Replies
hic
Former Employee
Former Employee

Try

If(Match(id_code,'8.2.28.','7.2.28.','24.2.28'), 'documentation_expertise')

juliakhaa
Creator
Creator
Author

The point is that I only know what the code ends in, that is, there will be a lot of codes where only the end will match, for example '.2.28'

hic
Former Employee
Former Employee

Try

If(WildMatch(id_code,'*.2.28'), 'documentation_expertise')

juliakhaa
Creator
Creator
Author

Can I use it on the case principle? Because I have a couple more such lines with other codes and at the end

Else 'No activity' end

tresesco
MVP
MVP

You can try like:

Pick(WildMatch(id_code, '*.2.28', '*.2.27', '*.2.29')+1, 'No Activity', 'case1', 'case2', 'case3')