Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

using match in set analysis

count({<field1={},match={field2,'',''}>}id)

am trying like did,its nt wrking

7 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you explain what you are trying to accomplish?  Do you want to select rows where field1 = field2?

-Rob

Anonymous
Not applicable
Author

can we use match in set analysis

Anonymous
Not applicable
Author

count({<field1={},match={field2,'some value','some value'}>}id)

karthikoffi27se
Creator III
Creator III

Hi Dy

what are you trying to do, can you explain it?

Thanks

Karthik

shiveshsingh
Master
Master

You need count of ID where Field2 is equal to  'some value','some value'?


=Count({<Field2 = {'some value','some value'}>}ID)

sunny_talwar

Might be easy if you can share few rows of raw data

Qlik Community Tip: How to Get Answers to Your Post

rubenmarin

Hi, just guessing... match() is used to check values, if you want to apply specific values to a field there is no need of using match, the syntax os set analysis expects that, ie:

Count({<Field2={'value1','value2'}>} id)