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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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