Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use "in" syntax in qlikview script?

Hi friends,

I have the following query in sql syntax:

select name,address,id from student where student_id in (12,76,89);

How to convert this SQL query to qlikview script?

I have written upto here

load   name,

         address,

          id

FROM

(qvd);

Any help is greatly appreciated.

13 Replies
Not applicable
Author

Hi Perumal,

I have explained the same Query in more detail in this link.

http://community.qlik.com/thread/74726

Please go through this page and guide me.

VishalWaghole
Specialist II
Specialist II

Hi,

Please try this one..

load   name,

          address,

          id

FROM

(qvd) WildMatch(student_id,'12','76','89');

Thanks,

Vishal.

Not applicable
Author

Thank You Vishal,

Please refer my exact query in the below link.

http://community.qlik.com/thread/74726

Please help me.

VishalWaghole
Specialist II
Specialist II

Hi Arun,

PFA of answer on link that you provide me, If still have doubt then revert to me.

Thanks and Regards,

Vishal Waghole