First half of nested if statements being ignored in load script

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

Hi, I am trying to use some if statements in a preceding load but only the second half is working, the first half just renders null.

I have tried with and without wrapping in the top if( but always the same result. I also tried doing the two halves separately and appending the second one to the first but that didn't work either.

LOAD *, if( if(DirectionPre = 'L' and HomeAway = 'H', 'LR'), if(DirectionPre = 'R' and HomeAway = 'H', 'RL') , if(DirectionPre = 'L' and HomeAway = 'A', 'RL', if(DirectionPre = 'R' and HomeAway = 'A', 'LR')) ) as Directionpre2;

Re: First half of nested if statements being ignored in load script

AyCe1082 — Thu, 11 Jun 2020 17:23:02 GMT

Solved

LOAD *, if(DirectionPre = 'L', if(HomeAway = 'H', 'LR', if(HomeAway = 'A', 'RL')), if(DirectionPre = 'R', if(HomeAway = 'H', 'RL', if(HomeAway = 'A', 'LR') ))) as Directionpre2;

topic Re: First half of nested if statements being ignored in load script in QlikView

First half of nested if statements being ignored in load script

Re: First half of nested if statements being ignored in load script