topic Re: Using created fields elsewhere in load script in QlikView

Using created fields elsewhere in load script

ljdlumley — Wed, 20 Mar 2013 12:16:54 GMT

Hi, I've looked all over and can't find an answer.

In my load script I have a number of IF statements,

Table1:

Load Field1,

Field2,

if (Field1>=30,1.5,if(Field1>=21,1,0)) as FlagField1

if (Field2>20 and Field2<90,0.5,0) as FlagField2

From abc.xlsx

These created fields work fine in my document but what I'm trying to do next is add all these Flag values (1-9) together to give an FlagOverall field within the load script.

Any ideas

John

Re: Using created fields elsewhere in load script

jonathandienst — Wed, 20 Mar 2013 12:23:12 GMT

The values Field1 and

Use preceding load like this:

Table1:

LOAD *,

FlagField1 + FlagField2 As FlagOverall

;

Load Field1,

Field2,

if (Field1>=30,1.5,if(Field1>=21,1,0)) as FlagField1

if (Field2>20 and Field2<90,0.5,0) as FlagField2

From abc.xlsx

Hope that helps

Jonathan

Re: Using created fields elsewhere in load script

ljdlumley — Wed, 20 Mar 2013 12:38:22 GMT

Thanks Jonathan. It works perfectly, quite counter intuitive to put it at the top of the script!

John

Re: Using created fields elsewhere in load script

hic — Wed, 20 Mar 2013 12:46:26 GMT

I would say that it is quite logical to put it on top, once you understand what it does...

See http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load

HIC

Re: Using created fields elsewhere in load script

ljdlumley — Wed, 20 Mar 2013 12:53:38 GMT

Thanks for the link, it makes sense now.

Re: Using created fields elsewhere in load script

stevelord — Fri, 26 Apr 2013 19:04:40 GMT

Life saver!