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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis 'not equal to ' syntax

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

22 Replies
Not applicable
Author

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
Partner - Contributor III
Partner - Contributor III

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

Not applicable
Author

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