Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic table creation and inserting values in it inside a script.

Hello techies,

Can any one help me out in creating a table dynamically inside the script.

Let me explain my situation clearly first.

I have 2 plants consisting of 20 and 25 QVDs each(some qvds are common in both the plants)

I have to load these qvds into qlikview and concatenate the common qvds and store this again in the form of a qvd.Besides this I have to store other uncommon qvds as well.

For these I used 2 For loops for loading both the plants QVDs exclusively.At the same time I want to create a dynamic table with a single column containing all the QVD names so that I can concatenate the common QVDs by using these QVD names and store.

Any help is greatly appreciated.

Cheers.

2 Replies
IAMDV
Master II
Master II

Hi,

Try using the below QlikView functions...

QVDTableName()

 

QVDNoOfFields()

QVDNoOfRecords()

QVDCreateTime()

QVDFieldName()

I hope this helps!

Cheers,

DV

www.QlikShare.com

Not applicable
Author

Hi,

Thank you for the reply.

I want to create a table dynamically which consist of single column containing all the qvd names.

Later I want to use the qvd names in this table to store the data into another consolidated qvd.

Is this possible in Qlikview?

Thx.