

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
not equal in set analysis
where homephone <> new_homephone
both are fields
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
Homephone -={'new_homephone'}
or,
Homephone ={'*'} - {'new_homephone'}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like:
Homephone -={'new_homephone'}
or,
Homephone ={'*'} - {'new_homephone'}


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i tried it....its not showing propere
it gives red underline below homephone(last)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's just a bug in the syntax checker. The syntax is correct. If the expression doesn't return the correct result please post a sample document that demonstrates the problem.
talk is cheap, supply exceeds demand


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The red underline before the -= is a QV bug, but the expression is correct.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Assuming that EmployeeID is unique ID
Try this
=Count({<msjvcode={1001}, msemploymentstatus={'A'}, EmployeeID={"=homephone<>new_homephone"}>} homephone)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
=count({<msjvcode={1000}, msemploymentstatus={'A'}, ~ homephone=new_homephone>} homephone)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi:
Let's be careful. It's not the same - = {'A'} means A is excluded, as
= {'*'} - {'A'} Means A is excluded but everything else is included even when is not in the actual selection.
I guess what you are looking for is = {'<>A'} that means A is excluded but still the expression obeys to the actual selection.
luck.
