topic Re: not equal in set analysis in QlikView

not equal in set analysis

saumyashah90 — Thu, 17 Oct 2013 10:30:19 GMT

where homephone <> new_homephone

both are fields

Re: not equal in set analysis

tresB — Thu, 17 Oct 2013 10:32:35 GMT

Try like:

Homephone -={'new_homephone'}

or,

Homephone ={'*'} - {'new_homephone'}

Re: not equal in set analysis

saumyashah90 — Thu, 17 Oct 2013 10:34:06 GMT

i tried it....its not showing propere

it gives red underline below homephone(last)

Re: not equal in set analysis

Gysbert_Wassenaar — Thu, 17 Oct 2013 10:35:24 GMT

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.

Re: not equal in set analysis

salto — Thu, 17 Oct 2013 10:36:24 GMT

The red underline before the -= is a QV bug, but the expression is correct.

Re: not equal in set analysis

CELAMBARASAN — Thu, 17 Oct 2013 10:37:16 GMT

Assuming that EmployeeID is unique ID

Try this

=Count({<msjvcode={1001}, msemploymentstatus={'A'}, EmployeeID={"=homephone<>new_homephone"}>} homephone)

Re: not equal in set analysis

Thu, 17 Oct 2013 10:42:51 GMT

Try:

=count({<msjvcode={1000}, msemploymentstatus={'A'}, ~ homephone=new_homephone>} homephone)

Re: not equal in set analysis

christian77 — Thu, 17 Oct 2013 11:13:59 GMT

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.