topic Re: Filter data based on Pattern Match in QlikView

Filter data based on Pattern Match

Tue, 19 Jan 2016 04:19:47 GMT

Hi All,

I have a load script where data has to be filtered based on [WBS Element].

I need data only starting with some [WBS Element] like

0043-,0053- , 0060-

Please help me in filtering data of this pattern.

Attached the Qvw.

Thanks,

Keerthi KS

jagan — Tue, 19 Jan 2016 04:26:03 GMT

Hi,

Try like this

LOAD

FROM DataSource

WHERE WildMatch([WBS Element], '0043-*','0053-*' , '0060-*');

Hope this helps you.

Regards,

jagan.

tresB — Tue, 19 Jan 2016 04:26:44 GMT

May eb like:

Load

From <> where Wildmatch([WBS Element], '0043-*','0053-*' , '0060-*');

arulsettu — Tue, 19 Jan 2016 04:27:08 GMT

try this

=if(WildMatch([WBS Element],'0043-*','0053-*' , '0060-*'),[WBS Element])

Tue, 19 Jan 2016 04:30:44 GMT

Thanks a lot Jagan