Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
1adam_haj
Contributor III
Contributor III

Cant see variable from Load Script

Hello i have set a variable in data load script but i cant see it in the edit mode of sheets

Table1

LOAD

Field1,

Field2

RESIDENT DATA_TABLE;

Table2

LOAD

Date

RESIDENT DATE_TABLE;

The variable looks like this

Let V_Name = IF(Date>1.3.2018,Field1,Field2);

What could be the problem ?

3 Replies
jaumecf23
Creator III
Creator III

Try thins:

IF(Date(peek ('Date',0,'Table2'))>Date#('1.3.2018','D.M.YYYY')) then

LET V_Name = peek ('Field1',0,'Table1') ;

else

LET V_Name = peek ('Field2',0,'Table1');

end if;

sasiparupudi1
Master III
Master III

You can not access the fields of resident table without using functions like peek or fieldvalue

Please post a sample app or your script so that we can advise you better