Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Creator III
Creator III

Your load statement miss of specified data source. 

Such as:

Load fields Resident tablename.

Or

Load fields;

Sql select ...

 

 

 

Highlighted
Partner
Partner

Hi TI

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

Highlighted
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

Highlighted
Partner
Partner

Thanks for you help!

 

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

Highlighted
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