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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?