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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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