SQL Like (...)

[Anonymous]

How can I use like () in QlikView?

[Sokkorn]

Hi,

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

Regards,

Sokkorn

[Anonymous]

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

[Sokkorn · Accepted solution]

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]

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

[Sokkorn]

Hi Sir,

Your welcome

Rgds,

Sokkorn