topic Reverse logic in loadscript in QlikView

Reverse logic in loadscript

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to create Flag using the below logic. Thanks

LOAD * INLINE [

ID, Base, Status

1, ABC, Open

2, DEF, Open

3, HIJ, Close

4, ABC, Close

5, HIJ, Close

6, ABC, Open

7, HIJ, Open

8, DEF, Open

9, DEF, Close

10, ABC, Close

];

Re: Reverse logic in loadscript

jensmunnichs — Thu, 18 Oct 2018 13:15:30 GMT

Maybe like this?

Temp: (Load inline)

Final:

LOAD

If(Status='Open', if(Base='ABC', 'Yes', 'No'), 'No') as Flag

Resident Temp;

Drop table Temp;

Re: Reverse logic in loadscript

poluvidyasagar — Thu, 18 Oct 2018 13:48:50 GMT

Jens answer is correct.

just modifying the if statement to differentiate 2 No's

Temp:

LOAD * INLINE [

ID, Base, Status

1, ABC, Open

2, DEF, Open

3, HIJ, Close

4, ABC, Close

5, HIJ, Close

6, ABC, Open

7, HIJ, Open

8, DEF, Open

9, DEF, Close

10, ABC, Close

];

Final:

Load *,

If(Status='Open', if(Base='ABC', 'Yes', 'No'), 'Other') as Flag

Resident Temp;

DROP Table Temp;

Re: Reverse logic in loadscript

jensmunnichs — Thu, 18 Oct 2018 14:01:18 GMT

You're right, I didn't even think about this. Though judging by OP's images anything that isn't ABC and Open gets a No flag anyway regardless of which condition fails. Nevertheless, good addition.