Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

1adam_haj
New 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
Contributor III

Re: Cant see variable from Load Script

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;

sureshqv
Esteemed Contributor III

Re: Cant see variable from Load Script

Highlighted
sasiparupudi1
Honored Contributor III

Re: Cant see variable from Load Script

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

Community Browser