Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tell me how to convert IIF(Right(Left(Purchase_order],7,5) = 0, Mid([Purchase_order], 8,5), Right(Left([Purchase_Order],7,5)) from Access to Qlikview? Thank you for your help.
Qlikview uses & to concatenate with so do that instead:
Select IDPON,
'0000' & If(Right(Left(([IDPON],7,5))) = 0, Mid([IDPON],8,5), right(Left([IDPON],7,5)) as NewPurchase_Order,
From ThisTable
Have you tried to use regular IF Statment? Because QlikView supports Right(), Left() & Mid() functions. Please post the sample QV file if possible.
IF(Right(Left(Purchase_order],7,5) = 0, Mid([Purchase_order], 8,5), Right(Left([Purchase_Order],7,5))
Thanks,
DV
Here is what I'm trying to do:
Select IDPON,
'0000' AND If(Right(Left(([IDPON],7,5))) = 0, Mid([IDPON],8,5), right(Left([IDPON],7,5)) as NewPurchase_Order,
From ThisTable
Qlikview uses & to concatenate with so do that instead:
Select IDPON,
'0000' & If(Right(Left(([IDPON],7,5))) = 0, Mid([IDPON],8,5), right(Left([IDPON],7,5)) as NewPurchase_Order,
From ThisTable
Thank you so much!