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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I want to use wildmatch in set analysis to count

My business problem is to count the question id which have been answered with a particular answer , for example the mapping answers are present in filed A which have values like "Yes/No" or "Yes" , " No'

and the actual answer present in field B which have answers as "yes' "No'

and i have perform count of question when answer type matches with the mapping answer field A. The challenge is coming when mapping field is having "Yes/No' in that scenerio if it has answered as "yes" or as "No " both cases should be counted.

I am using below query which is not working:

Count({$<Acronym=P(Acronym), wildmatch(B,A)>}UID)/ count(Evaluation_ID)

1 Reply
sunny_talwar

Would you be able to share few rows of data and explain as to what you are looking to get as an output?