topic Re: Yes/No Flag in load script in QlikView

Yes/No Flag in load script

Anonymous — Thu, 21 May 2015 17:54:28 GMT

Hey everyone,

So I have a field called order type and I want to take the last two characters of the values that have "BD", and make a Yes/No bucket or a BD Flag dimension with values Y and N.

So something like

If(OrderType='BD','Y','N')

But I know I'm missing the part that specifies BD as the last two characters.

Thanks

Rocco

Re: Yes/No Flag in load script

Anonymous — Thu, 21 May 2015 17:56:20 GMT

Hello

if(right(OrderType,2)='BD','Y','N')

Regards

Re: Yes/No Flag in load script

Oleg_Troyansky — Thu, 21 May 2015 17:58:21 GMT

the function you are looking for is Right(). Also, I recommend defining a numeric flag, instead of alphanumeric. Your expressions with the flag will be much more efficient:

If(Right(OrderType, 2)='BD',1,0)

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

Re: Yes/No Flag in load script

MarcoWedel — Thu, 21 May 2015 23:26:04 GMT

Hi,

one possible solution could be also:

LOAD *,
    If(OrderType like '*BD',Dual('Y',-1),Dual('N',0)) as [BD Flag]
Inline [
OrderType
GHIJKLBDMNOPQRST
ABHIJKLMNOPXYZBD
BCDEFGOPQRYZ
DEFGTUVWXYZ
DEFGHIJKLQRSYZ
DEFMNSTUVWXBD
FGHIJKLMNOPQRSTUV
CDEFGHIJKLMNOUBD
BDEFGHIJKLMWXYZ
GHIJKLMNOPQRSTUBD
CDEFGHIJKLMNOPQRXYZ
FGHIBDLMNOPQRSTUVWZ
]

Creating dual values allows you to use the BD Flag field e.g. like this:

hope this helps

regards

Marco