topic Re: What does '<>'implies ?? in QlikView

What does '<>'implies ??

nikhilgarg — Mon, 05 Jan 2015 07:39:16 GMT

Hey,

What is the use of <> sign in following :

if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

Thanks

Re: What does '<>'implies ??

Anonymous — Mon, 05 Jan 2015 07:44:55 GMT

<> refers to not equal sign

Re: What does '<>'implies ??

Mon, 05 Jan 2015 07:46:19 GMT

Hi Nikhil,

<> sign is equivalent to 'not equal'.

if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

Here if the First 3 Characters of BranchCode is not equal to MergeCode then value of the field MergeCode will get stored in NewBranch else First 3 Characters of Branch Code will get stored in NewBranch .

Hope, it hepls you.

Regards,

Ankur

Re: What does '<>'implies ??

Anonymous — Mon, 05 Jan 2015 07:49:44 GMT

'<>' not equal sign .

Refer this link for more info Expressions

Re: What does '<>'implies ??

rubenmarin — Mon, 05 Jan 2015 08:57:29 GMT

As said above, it's the operator for 'not equal', in this case I don't think is needed in the expression you post, you can directly use:

MergeCode as NewBranch

In your expression if "left(BranchCode,3)" is not equal to "MergeCode" then gets "MergeCode"

If it's equal it takes "left(BranchCode,3)" but if it's equal to "MergeCode" is the same to get "MergeCode"

Re: What does '<>'implies ??

Anonymous — Mon, 05 Jan 2015 09:03:03 GMT

'<>' refers to not equal sign

Re: What does '<>'implies ??

alkesh_sharma — Mon, 05 Jan 2015 09:10:35 GMT

Hyi..

'<>' implies ' not equal to' or opposite of '='

Re: What does '<>'implies ??

its_anandrjs — Mon, 05 Jan 2015 09:19:57 GMT

Hi,

In the expression if(left(BranchCode,3)<>MergeCode,MergeCode,left(BranchCode,3)) as NewBranch

in this line if(left(BranchCode,3)<>MergeCode,MergeCode if condition true you fetch the MergeCode data where left(BranchCode,3)<>MergeCode means it is other rows.

And if false you fetch left(BranchCode,3).

And here <> means not equals.

Regards

Anand