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: 
Swtnk02
Contributor
Contributor

How to store Variable values anywhere be it QVD or table or inline

Hi There.

I had a query regarding storing variable values.

What i want to achieve:

Suppose a variable named  vID is created.

We assign some value to it Say 'Swtnk02'

i want to store it in some table such that when we change the variable value to 'Pk0012'

the table will consist both Swtnk01 and Pk0012 in it and so on.

 

I tried doing this but still the data gets updated for the latest Variable value given

UserDetail:
Load * Inline [
Id,Type
P01,Principal
P02,Principal
S01,Student
S02,Student
T01,Teacher
T02,Teacher
$(vID),$(vType)
];

Store UserDetail into [lib://DataFiles/userDetails.qvd](qvd);

Drop table UserDetail;


LOAD
Id,
"Type"
FROM [lib://DataFiles/userDetails.qvd]
(qvd);

Labels (1)
1 Reply
Swtnk02
Contributor
Contributor
Author

*found a way