Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
ashok555
New Contributor III

Storing Field value to Variable

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);

1 Solution

Accepted Solutions
ashok555
New Contributor III

Re: Storing Field value to Variable

For loop Solved the issue.

View solution in original post

1 Reply
ashok555
New Contributor III

Re: Storing Field value to Variable

For loop Solved the issue.

View solution in original post