topic Re: Store a field into a variable in Qlik Learning Discussions

Store a field into a variable

Fri, 12 Sep 2014 13:17:22 GMT

Hi everyone,

I'm trying to create a table with some years starting from a label field.

I have the label PRICE_2013 and with the instruction:

Right (@37,4) as starting_Year

I can get 2013 tha is the starting year of my study. Now I'd like to put this starting_Year into a variable ($vyear) in order to make a loop and icrease automatically the value of the year like this:

//first year

LOAD

$(vyear) as Year,

...

////Second year

//LOAD

//($(vyear)+'1') as Year,

.....

....

I tried to set as variable with GetFieldSelections() but It doesn't work because It doesn't recognize the filed starting_Year, maybe because It don't see 2013 as an integer but as a string i don't know!

Maybe somebody can help!

Re: Store a field into a variable

Fri, 12 Sep 2014 15:05:12 GMT

Hi Ylenia,

maybe this helps you to answer your question:

// preparing raw input data:

InitData:

LOAD

Right ('PRICE_2013',4) AS StartYear

AutoGenerate 1;

// fill Variable

LET vStartYear = Peek('StartYear');

//exampl for next 3 years:

LOAD

$(vStartYear) + RecNo() AS MyYear

AutoGenerate 3;

Roland

Re: Store a field into a variable

Sarah_Miller — Mon, 15 Sep 2014 18:26:42 GMT

Hi Ylenia,

Thank you for your interest in QlikView and thank you for participating in the Education Services Forum. For the future, please only use the category "QlikView" questions when asking specific QlikView questions. The Tips and Trips and announcements are meant to share important information, not to store questions.

Many thanks,

Sarah Miller