Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Script Related Issue

Hello All,

I am encountering error while using the below script. I think 1st 2 Lines are Okay but third lines seems to be having an issue.

If(IsNull("DPN30"),'T','F') as [NEW1],

if("DPN30"="DPN",'T','F') as [NEW2],

If('NEW2'='F' and 'NEW1' = 'T','N','O') as [NEW3],

Kindly help me in this.

1 Reply
sunny_talwar
Not applicable

Re: Script Related Issue

Are you loading this in the same load? or are you doing the NEW3 in a preceding load? Try like this:

LOAD *,

           If([NEW2] = 'F' and [NEW1] = 'T', 'N', 'O') as [NEW3];

LOAD If(IsNull("DPN30"),'T','F') as [NEW1],

           If("DPN30"="DPN",'T','F') as [NEW2],

          OtherFieldNames.....

FROM ....;

Read about Qlik Design Blog : Preceding Load | Qlik Community