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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
hosasahana
Partner - Contributor III
Partner - Contributor III

wildmatch

I am trying to use wild matc in my set analysis,but doesnt work. Please can anyone help look into my code n say if its correct? or I want to know how do we use "IN" condition in set analysis.

 

 

hosasahana_0-1604494768451.png

 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

why do you need to use wildmatch there? the syntax is not correct for set analysis.

i am assuming you are checking id id is one of the values. so use below instead

avg({<instance.id={'A','B','C','D'},metric={'ABC'},............

View solution in original post

6 Replies
dplr-rn
Partner - Master III
Partner - Master III

why do you need to use wildmatch there? the syntax is not correct for set analysis.

i am assuming you are checking id id is one of the values. so use below instead

avg({<instance.id={'A','B','C','D'},metric={'ABC'},............

dplr-rn
Partner - Master III
Partner - Master III

if you want to use wildcard double quotes and * like below

instance.id={"B*"}

hosasahana
Partner - Contributor III
Partner - Contributor III
Author

great.. so this acts the SQL "IN "condition right?

dplr-rn
Partner - Master III
Partner - Master III

yes

dplr-rn
Partner - Master III
Partner - Master III

close thread by mark as answered if no further questions

hosasahana
Partner - Contributor III
Partner - Contributor III
Author

thanku so much for the help