Convert Access IIF to Qlikview

[#1]

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.

[IAMDV]

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

www.QlikShare.com

[#3]

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

[calvindk · Accepted solution]

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

[#5]

Thank you so much!