set analysis 'not equal to ' syntax

[#1]

Hi All,

I want to achieve the foll: with set analysis

count of id where field a<> field b

i tried  '<>' and '-='.

But, both did not work.

Please help me out.

Thanks,

Anju

[#2]

Thank You!

Yes,

it is giving me the correct result.

But, what if , they were to introduce values other than 0 and 1?

[cn_sa_dev]

Hi Anju,

I'm not aware of a way to compare two fields in set analysis - searching through the community I didn't see any answers either:

Set Analysis Issue - Comparing two Fields

Set analysis - comparing two field

You could either use an IF, or use exclusions as I did above with set analysis.  If you use the set analysis exclusions you will have to hardcode the values as you can't directly compare them - so if the values change the set analysis will also have to change.  Not an elegant solution but it's a workaround.

I've created an idea for this, please vote for it if you'd like this functionality in set analysis... 

http://community.qlik.com/ideas/3184

[#4]

As per the Reference Maual: " If you want to force exclu- sion of specific field values, you will need to use “~” in front of the field name. "

<~YOURFIELDA = YOURFIELDB>

That would be the same as YOURFIELDA <> YOURFIELDB