topic Re: How Do I create new variable based on a formulated variable in load editor (Qlikview) in QlikView

How Do I create new variable based on a formulated variable in load editor (Qlikview)

hykal1993 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

When I generated below it doesn't work. How do I use back the variable I just set, thanks.

LOAD

[Open Date],

If(year([Open Date])=year(now()) and month([Open Date])=month(now())-1, 'Yes','No') as [V1-5],

If([V1-5] = 'No', 'Exclude', 'Include') as [Exclude?]

Re: How Do I create new variable based on a formulated variable in load editor (Qlikview)

Gysbert_Wassenaar — Thu, 04 Oct 2018 10:16:03 GMT

With a preceding load. The new field [V1-5] has to exist before you can use it.

LOAD

If([V1-5] = 'No', 'Exclude', 'Include') as [Exclude?]

;

LOAD

[Open Date],

If(year([Open Date])=year(now()) and month([Open Date])=month(now())-1, 'Yes','No') as [V1-5],

.... other fields

FROM

...somewhere

Re: How Do I create new variable based on a formulated variable in load editor (Qlikview)

hykal1993 — Thu, 04 Oct 2018 10:30:42 GMT

Do you mean define [V1-5] first because what you wrote above is the other way around.

Also, when I load again, do I need to load the data again and after FROM do I need to point back to the data source

Re: How Do I create new variable based on a formulated variable in load editor (Qlikview)

shwethaa — Thu, 04 Oct 2018 10:35:21 GMT

Refer Preceding Load for preceding load.

In Preceding Load below code will be executed first

LOAD

[Open Date],

If(year([Open Date])=year(now()) and month([Open Date])=month(now())-1, 'Yes','No') as [V1-5],

.... other fields

FROM

...somewhere

then

LOAD

If([V1-5] = 'No', 'Exclude', 'Include') as [Exclude?]

;

It takes input from previous load.

Re: How Do I create new variable based on a formulated variable in load editor (Qlikview)

hykal1993 — Thu, 04 Oct 2018 11:33:28 GMT

LOAD

[Open Date],

If(year([Open Date])=year(now()) and month([Open Date])=month(now())-1, 'Yes','No') as [V1-5],

.... other fields

FROM

[source path]

then

LOAD

If([V1-5] = 'No', 'Exclude', 'Include') as [Exclude?]

;

FROM

[ What should I write here??]

Re: How Do I create new variable based on a formulated variable in load editor (Qlikview)

shwethaa — Thu, 04 Oct 2018 14:19:12 GMT

LOAD

If([V1-5] = 'No', 'Exclude', 'Include') as [Exclude?]

;

This statement must be above previous load statement. And from is not required. As gysbert mentioned.