topic Creating a feild in a script. in QlikView

Creating a feild in a script.

Wed, 09 Dec 2009 21:30:42 GMT

I have two fields that I would like to use to create a new field ( simply one field minus the other). I need to create this field to use it in set analysis. I have attemped to use the formula below in my script with now luck

Set New Field = Field1-Feild2;

Any suggestions?

Thank you!

Creating a feild in a script.

Wed, 09 Dec 2009 21:34:43 GMT

How about adding it to your load script?

i.e.

LOAD *, Field1-Field2 as "New Field";

Creating a feild in a script.

Anonymous — Wed, 09 Dec 2009 21:36:15 GMT

Hi jhoffman ,

I'm not sure if I understood you well, but you could try to use the LET statement instead of SET.

So,

LET Field = Field1-Feild2;

would result in a difference between the two fields.

I guess this is what you are looking for.

Valera 🙂

Creating a feild in a script.

Thu, 10 Dec 2009 04:40:09 GMT

Thanks for the help!! I should have been more clear with my issue , but adding my new field to the load script allowed me to use it in set analysis.

Thanks again,

Jeff