topic Re: OR AND operators in set analysis in QlikView

OR AND operators in set analysis

Tue, 15 Oct 2013 08:39:39 GMT

Hi All,

help me in this set analysis:

I need to consider activities with start into an interval defined by two variable either activities with start before interval with end after interval

Only

(

{$ <

TIME_BEGIN = {'>$(TimeBeginZ)<$(TimeEndZ)'}

{

TIME_END = {'>$(TimeEndZ)'}

AND

TIME_BEGIN = {'<$(TimeBeginZ)' }

}

TIME_END-TIME_BEGIN

)

How can I insert the second set?

Only

(

{$ <

TIME_BEGIN = {'>$(TimeBeginZ)<$(TimeEndZ)'}

} +

{$ <

TIME_END = {'>$(TimeEndZ)'},

TIME_BEGIN = {'<$(TimeBeginZ)' }

}

TIME_END-TIME_BEGIN

)

Thanks in advance

Corrado

Re: OR AND operators in set analysis

tresB — Tue, 15 Oct 2013 08:58:36 GMT

Try like:

Only

(

{$ <

TIME_BEGIN = {'>$(TimeBeginZ)<$(TimeEndZ)'}

< TIME_END = {'>$(TimeEndZ)'}>

< TIME_BEGIN = {'<$(TimeBeginZ)' } >

}

TIME_END-TIME_BEGIN

)

Edit: Corrected the brackets.

Re: OR AND operators in set analysis

Tue, 15 Oct 2013 09:38:30 GMT

Hi Corrado,

try this too

Only

(

{$ <

TIME_BEGIN = {'>$(TimeBeginZ)<$(TimeEndZ)'}

< TIME_END = {'>$(TimeEndZ)'}, TIME_BEGIN = {'<$(TimeBeginZ)' } >

}

TIME_END-TIME_BEGIN

)

Regards

Hilic

Re: OR AND operators in set analysis

Tue, 15 Oct 2013 09:44:32 GMT

Thanks all,

the answers are all correct.

Regards

Corrado