Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Cold_Fire
Contributor
Contributor

expression sql in qlikview

Hi All,

 

I want this query translate in qlikview 

select ETP_SOSR where ETP_SOSR= 'IU_ENROLLMENT_LOGIN'

Any help please

Thank you in advance

Labels (1)
2 Replies
Saravanan_Desingh

LOAD ETP_SOSR 
Resident tab1 
Where ETP_SOSR= 'IU_ENROLLMENT_LOGIN'
MayilVahanan

HI @Cold_Fire 

You can use the same query in Qlikview itself.

Sql Load:

SQL select ETP_SOSR where ETP_SOSR= 'IU_ENROLLMENT_LOGIN';

or

Qvd load:

load * from yoursourceqvd where ETP_SOSR= 'IU_ENROLLMENT_LOGIN';

or

Preceeding Load: 

Load  * where ETP_SOSR= 'IU_ENROLLMENT_LOGIN';

select ETP_SOSR from yoursourcetable;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.