topic Re: Convert Access IIF to Qlikview in QlikView

Convert Access IIF to Qlikview

Mon, 01 Jul 2013 17:34:13 GMT

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.

Re: Convert Access IIF to Qlikview

IAMDV — Mon, 01 Jul 2013 18:39:57 GMT

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,

www.QlikShare.com

Re: Convert Access IIF to Qlikview

Mon, 01 Jul 2013 18:49:10 GMT

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

Re: Convert Access IIF to Qlikview

calvindk — Mon, 01 Jul 2013 20:55:39 GMT

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

Re: Convert Access IIF to Qlikview

Tue, 02 Jul 2013 14:15:27 GMT

Thank you so much!