Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to import only sql if load is wriiten?

assume i have sql query in a text file. i have to import it in qlikview. the query is just the sql part and the load statement i will write myself. how to do that?

example:

LOAD...

.....

...

.....

SQL

this part will be taken from text file. how to do that?

13 Replies
Not applicable
Author

okay thanks. I will try this once.

Not applicable
Author

how to save as qvs?

sinanozdemir
Specialist III
Specialist III

open up the txt file and hit "save as" and re-name the extension as qvs:

Capture.PNG

Capture2.PNG

When you create the include statement, browse to the directory where you save the qvs file. Finally, add a preceding load on the top of it.

Capture4.PNG

Not applicable
Author

Thanks a lot. It worked