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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create QVD's through variable ?

How to create QVD's through variable ?

please call me or whats app on 91958181000

2 Replies
felipedl
Partner - Specialist III
Partner - Specialist III

Vikram,

can you give more details on what you need?

Do you need to store a QVD with a specific name based on a varialbe?

If you need something like this, you can use $ (dollar) expansion, like below:

set vName = Test;

tmp:

Load

     'A' as Test

Autogenerate(1);

store tmp into $(vName).qvd (qvd);

This will store a QVD named Test.qvd into the same folder where you save the QVW with the above code.

Most operations will use the $ expansion when you need to get values from a variable.

MK9885
Master II
Master II

SET run_path = '..\qvd\';

after you load the data

STORE XYZ_TABLE into $(run_path)XYZ_TABLE.qvd (qvd);

.. can be tricky. single . means 1 folder up, .. would mean 2 folder up

and ..\qvd\ would be your store location in script