AND-OR in Qlikview Expression

[#1]

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]

This?

IF(

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

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

<Your expression for TRUE>,

<Your expression for FALSE>

)

[#3]

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]

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]

OR ('+'):

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

Similarly for AND you can use '*' operator

[#6]

Thanks All.

Let me try .