topic Re: multiple if condition in QlikView

multiple if condition

Mon, 20 May 2013 06:07:13 GMT

AOA

i want to execute this statemnt as expression.

IF sum(bal_qty)>0,'up'

IF sum(bal_qty)<0,'down'

IF sum(bal_qty)=0,'No change'

so what would be the expresion for this!!!!!!!!!

i tried

if(sum(bal_qty)>0,'up','down')

its work fine on two condition up and down

how to deal with third one when sum(bal_qty) = 0

???

kumarnatarajan — Mon, 20 May 2013 06:21:07 GMT

hi,

try this one.

if(sum(bal_qty)=0,'No change',

if(sum(bal_qty)>0,'up',

if(sum(bal_qty)<0,'down',

)))

oleg_orlov — Mon, 20 May 2013 06:33:43 GMT

Hello! Try something like that:

if (Sum (bal_qty) > 0,

'up',

if (Sum (bal_qty) < 0,

'down',

'No change'

)

Mon, 20 May 2013 08:45:30 GMT

Both answer are correct.......