Discussion board where members can get started with QlikView.
When I generated below it doesn't work. How do I use back the variable I just set, thanks.
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?]
This statement must be above previous load statement. And from is not required. As gysbert mentioned.
View solution in original post
With a preceding load. The new field [V1-5] has to exist before you can use it.
.... other fields
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
Refer Preceding Load for preceding load.
In Preceding Load below code will be executed first
It takes input from previous load.
[ What should I write here??]