Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Motorsport28
Partner - Contributor II
Partner - Contributor II

Creating QVD

Hi guys

 

Im hoping someone can help. Im trying to create a QVD from a table which i have given the name Ëmployees but keep getting the error that employees cannot be found? 

 

 
1 Solution

Accepted Solutions
thi_pham
Creator III
Creator III

The sql statement should be located right after load, like: 

Load fields;

Sql select fields from datatable;

 

View solution in original post

5 Replies
thi_pham
Creator III
Creator III

Your load statement miss of specified data source. 

Such as:

Load fields Resident tablename.

Or

Load fields;

Sql select ...

 

 

 

Motorsport28
Partner - Contributor II
Partner - Contributor II
Author

Hi TI

So i have the SQL Statement i have attached a complete screenshot

thi_pham
Creator III
Creator III

The sql statement should be located right after load, like: 

Load fields;

Sql select fields from datatable;

 

Motorsport28
Partner - Contributor II
Partner - Contributor II
Author

Thanks for you help!

 

I placed the script beneath the sql select statement and it worked! Much appreciated

marksouzacosta
Partner - Creator II
Partner - Creator II

Hi,

We just released a new video in our YouTube channel that may help others looking for some extra info on how to create QVDs. I hope it helps!

IPC Global Tips #6 - Creating QVDs - Regular and Incremental Loads
https://youtu.be/S9L6vWItchs

 

Regards,

Mark Costa

Get hooked on Qlik at qlikbait.net