Creating QVD and loading qvd

[Santanunandy]

Hi all, 

I am new to qlik and looking out for two solutions.

1.Suppose I have a table like [Name , Address, sales start date] and I would like to create qvd based on Name field for better management . How do I do that and looking out for a sample script.

2.using the example above suppose using the "Name"  I have got around 10,000 QVD and each qvd say have got 1 Million record, eg John.qvd ,Mary.qvd and so on . When the user selects the name I would like to fetch only Mary.qvd for faster response rather than fetching all the QVD's .Can some body provide me sample code ?

[rwunderlich · Accepted solution]

With regards to 2), take a look at On Demand Apps https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/DataSource/Manage-bi...

Regarding 1), do you have multiple Name values in the table and want to split into separate QVDs? If you have only a single name value it's as easy as:

Let vName = FieldValue('Name', 1);

Store Sales into [$(vName)-Sales.qvd] (qvd);

-Rob