Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II
Creator II

How to fetch only those records which contain the required string?

If the column contains following records/values. How can we fetch only those records which contains TEST? for example, in below data set 2 records contain "TEST". So my question is how can i fetch only that and ignore rest of the records. Please help! It is little urgent

tfgty@erery@yktyik@ytyityi@yityi

tytyityi@dhrtrtu@TEST@rtrt@trurtu

tut@gttyty@gtjgvj@ttrurtu@tgrujrtu

11 Replies
manideep78
Partner - Specialist
Partner - Specialist

Hi,

Yes, we can absolutely use LIKE statement in Qlikview. Its function is same as it is in SQL. You can check it out. You can able to see intellisense coming over there if you type it. Please go through reference manual as well. It comes under String Operators.

PFA !

Regards,

Manideep

Not applicable

Thanks Colin, for substatiating my point.