topic Re: AND-OR in Qlikview Expression in QlikView

AND-OR in Qlikview Expression

Wed, 14 Aug 2013 07:02:20 GMT

Hi,

I am new to Qlikview.I am struggling hard to get the below conditions into an expression.

Any ideas??

(JoinDate < Getdate() And Active = 1) OR

(JoinDate <= Getdate() And TerminationDate >=Getdate() And Active = 0)

tresB — Wed, 14 Aug 2013 07:08:54 GMT

This?

IF(

(JoinDate < Getdate() And Active = 1) OR

(JoinDate <= Getdate() And TerminationDate >=Getdate() And Active = 0),

<Your expression for TRUE>,

)

Wed, 14 Aug 2013 07:11:34 GMT

No I want the Expression in this format:

I am taking Count(Distinct USerID) based on two conditions.If i have to Use OR how should i extend my expression?

Count({<JoinDate={'<$(=Only(EndDate))'},Active={0}>} Distinct UserID)

Gysbert_Wassenaar — Wed, 14 Aug 2013 07:16:38 GMT

For the OR condition in the set modifier you can use the + operator:

Count({<JoinDate={'<$(=Only(EndDate))'},Active={0}>+<...Second set of conditions here...> } Distinct UserID)

tresB — Wed, 14 Aug 2013 07:17:17 GMT

OR ('+'):

Count({<JoinDate={'1/1/12'}> + <Active={0}>} Distinct) // just an example for OR (here + operator)

Similarly for AND you can use '*' operator

Wed, 14 Aug 2013 07:21:58 GMT

Thanks All.

Let me try .