Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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