topic Re: using match in set analysis in QlikView

using match in set analysis

Anonymous — Thu, 15 Feb 2018 06:28:08 GMT

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

am trying like did,its nt wrking

Re: using match in set analysis

rwunderlich — Thu, 15 Feb 2018 06:42:35 GMT

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

-Rob

Re: using match in set analysis

Anonymous — Thu, 15 Feb 2018 07:35:10 GMT

can we use match in set analysis

Re: using match in set analysis

Anonymous — Thu, 15 Feb 2018 07:38:09 GMT

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

Re: using match in set analysis

karthikoffi27se — Thu, 15 Feb 2018 07:49:28 GMT

Hi Dy

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

Thanks

Karthik

Re: using match in set analysis

shiveshsingh — Thu, 15 Feb 2018 11:04:16 GMT

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

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

Re: using match in set analysis

sunny_talwar — Thu, 15 Feb 2018 12:09:28 GMT

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

Qlik Community Tip: How to Get Answers to Your Post

Re: using match in set analysis

rubenmarin — Thu, 15 Feb 2018 12:20:28 GMT

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)