topic Find the series between multiple number in QlikView

Find the series between multiple number

sona_sa — Thu, 04 Oct 2012 10:23:07 GMT

Hi,

I have some series like this

IWG10SAD0260000

IWG10SAD0280000

IWG10SAD0250000

IWG10SAD0050000

IWG10SAD0290000

IWG10SAD0060000

IWG12GAN0150000

IWG12BAR0010000

IWG12BEH0010000

IWG12BHA0030000

IWG12BET0050000

IWG12BET0030000

IWG12ADO0020000

IWG12BET0040000

IWG11VAJ0400000

IWG11VAJ0320000

IWG11VAJ0310000

IWG11VAJ0330000

IWG11VAJ0300000

Now I want only those number which start from IWG11 and IWG12.

How I can do it from edit script.

Thanks & Regards,

A Kumar

swuehl — Thu, 04 Oct 2012 10:27:35 GMT

Maybe like

LOAD

FIELD

FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';

Thu, 04 Oct 2012 10:28:27 GMT

Hi,

You can try somthing like this,

Load

Data

from Sample.xls

where left(Data,5) = 'IWG11' OR left(Data,5) = 'IWG12';

Regards,

Alex