Storing Field value to Variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a column named "ForecastFileName" which contains a text value for one row and remaining rows are null.

Now i would like to store that one text value to a variable.

Is there a better way than below? I have few more columns which need to be stored to variables, So if i use the following it will be repetitive code. suggestions are appreciated.

Temp:

load ForecastFileName

Resident Table1

where not isnull(ForecastFileName);

let v_RequiredName=Peek('ForecastFileName',0,Temp);

Re: Storing Field value to Variable

Anonymous — Fri, 30 Sep 2016 11:43:01 GMT

For loop Solved the issue.

topic Storing Field value to Variable in QlikView

Storing Field value to Variable

Re: Storing Field value to Variable