Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Motorsport28
Partner
Partner

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
Partner
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;

 

View solution in original post

Motorsport28
Partner
Partner
Author

Thanks for you help!

 

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

mark_costa
Partner
Partner

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