Discussion Board for collaboration related to QlikView App Development.
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?
A couple of approaches
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.
See this discussion for some of the basics
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..