topic Re: true or false in QlikView

true or false

raadwiptec — Wed, 16 Dec 2015 15:36:25 GMT

hi alli,

this is my scenario

column A ! Column B ! Final

False False False

False True True

True False True

True True True

I need suggestion to get final column

Re: true or false

sunny_talwar — Wed, 16 Dec 2015 15:41:36 GMT

May be something like this:

If(Upper([column A])&'|'&Upper([Column B]) = 'FALSE|FALSE', 'False', 'True') as Final

SAMPLE:

Table:

LOAD *,

If(Upper([column A])&'|'&Upper([Column B]) = 'FALSE|FALSE', 'False', 'True') as Final;

LOAD * Inline [

column A, Column B

False, False

False, True

True, False

True, True

];

Re: true or false

Colin-Albert — Wed, 16 Dec 2015 15:48:30 GMT

The final table is a Boolean AND of Column A and Column B.

If these fields hold correct True (-1) and False (0) values, then you can use columnA AND columnB

QlikView has the following Boolean operators

Logical Operators

All logical operators interpret the operands logically and return true (-1) or false (0) as result.

not	Logical inverse. One of the few unary operators. The operation returns the logical inverse of the operand.
and	Logical and. The operation returns the logical and of the operands.
or	Logical or. The operation returns the logical or of the operands.
Xor	Logical exclusive or. The operation returns the logical exclusive or of the operands. I.e. like logical or, but with the difference that the result is false if both operands are true.

Re: true or false

datagrrl — Wed, 16 Dec 2015 15:58:54 GMT

I deleted my original reply instead of editing it to correct the case on my expression.

Is there a reason you would do this instead of

If(Upper([Column A])='FALSE' and Upper([Column A]) ='FALSE', 'False', 'True')

I know they both work. Is my way against the best practice, poor performing or just a different way of doing it?

I am mostly self taught, so I think a lot about whether my expressions are performance hogs. Any feedback is appreciated.

Re: true or false

raadwiptec — Wed, 16 Dec 2015 16:03:49 GMT

HI SUNNY,

IN EXPRESSION? IS IT POSSIBLE

Re: true or false

effinty2112 — Wed, 16 Dec 2015 16:16:45 GMT

This should do it:

Column A	Column B	if([Column A] ='False' and [Column B] = 'False', 'False','True')
False	False	False
False	True	True
True	False	True
True	True	True

Re: true or false

sunny_talwar — Wed, 16 Dec 2015 16:17:15 GMT

Try this as your expression:

If(Upper([column A])&'|'&Upper([Column B]) = 'FALSE|FALSE', 'False', 'True')

Re: true or false

eduardo_sommer — Wed, 16 Dec 2015 16:21:18 GMT

In fact it's OR instead of AND

AND is True Only when both are True

Eduardo

Re: true or false

raadwiptec — Thu, 17 Dec 2015 07:35:33 GMT

HI All,

Thanks. All the answers are correct. I choose one . I will mark it as correct answer.

thanks

Re: true or false

Colin-Albert — Thu, 17 Dec 2015 12:39:35 GMT

Oops! Its a long time since I looked at ANDs ORs and XORs 🙂

Re: true or false

Colin-Albert — Thu, 17 Dec 2015 12:41:46 GMT

As pointed out by Eduardo this should be OR instead of AND

The final table is a Boolean AND OR of Column A and Column B.

If these fields hold correct True (-1) and False (0) values, then you can use the expression

= columnA OR columnB

Re: true or false

MarcoWedel — Thu, 17 Dec 2015 21:33:46 GMT

Hi,

another solution using dual values could be:

table1:
LOAD Pick(Wildmatch(A,'false','true'),Dual('False',0),Dual('True',-1)) as A,
     Pick(Wildmatch(B,'false','true'),Dual('False',0),Dual('True',-1)) as B
INLINE [
    A, B
    False, False
    False, True
    True, False
    True, True
];

hope this helps

regards

Marco