Cant see variable from Load Script

[1adam_haj]

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 ?

[jaumecf23]

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;

[Chanty4u]

check here

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ScriptVariables.htm

[sasiparupudi1]

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