Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.