topic Re: SQL Like (...) in QlikView

SQL Like (...)

Anonymous — Tue, 16 Jul 2013 01:28:24 GMT

How can I use like () in QlikView?

Sokkorn — Tue, 16 Jul 2013 01:33:50 GMT

Hi,

In QlikView we can use Match() and WildMatch function.

Regards,

Sokkorn

Anonymous — Tue, 16 Jul 2013 01:34:56 GMT

Sokkorn, thanks for quick replied. Can you give some example? I'm very new.

Sokkorn — Tue, 16 Jul 2013 01:39:07 GMT

Hi,

Some example:

[Data]:

Load

Field1,

Field2,

Field3 Where Match(Field1,'Value1','Value2','Value3');

Select Field1,Field1,Field3 From MyTable;

And if you want wildcard then use Where WildMatch(Field1,'*Value1*','*Value2*','*Value3*');

Match() and WildMatch() will work same in your epxression. And you can check more details in help (F1) for those two functions.

Regards,

Sokkorn

Anonymous — Tue, 16 Jul 2013 01:41:50 GMT

Wow it work like a charm. Thank you so much Sokkorn. Very quick response.

Sokkorn — Tue, 16 Jul 2013 01:42:33 GMT

Hi Sir,

Your welcome

Rgds,

Sokkorn