Qlik Community

Ask a Question

App Development

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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