Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i have 6 tables loaded into qlikview in 6 tabs? i want create a single qvd for all 6 tables ? i dont want 6 qvds i want only one qvd?how?

i have 6 tables loaded into qlikview in 6 tabs? i want create a single qvd for all 6 tables ? i dont want 6  qvds i want only one qvd?how?

3 Replies
marcus_malinow
Specialist III
Specialist III

A couple of approaches

JOIN

or

CONCATENATE

Which is appropriate is dependant on your data structures. Are all your tables structured in the same way? Is data in one table exclusive to that in another.  If so, CONCATENATE.

Or is the data related. That is you have records in different tables which relate to each other. If so, JOIN.

marcus_malinow
Specialist III
Specialist III

http://community.qlik.com/message/441911#441911

See this discussion for some of the basics

sasikanth
Specialist III
Specialist III

Hi

Irrespective of How many tables that you have , one thing is sure

Finally you can store a single table into QVD,

if you have n number of tables , if you dont want to merge them , then you have to create n QVDS

Others wise go For CONCATENATE , JOIN....Use these to combine all your tables in to one and then Store the Single result set in to QVD..