topic Re: How to create field after load statement in QlikView

How to create field after load statement

Anonymous — Thu, 03 May 2018 08:58:01 GMT

Okay so this is a simple question, but for the life of me i cant figure it out. My code below as inefficient... How can i move the section of code where I create VaccYear, into the previous table statement, such that I don't have to load a table twice....

[ForecastTableTemp]:

Crosstable(VaccName,FcQty)

LOAD *

Resident Table;

Drop table Table;

[ForecastTable]:

LOAD *,

VaccName & [Forecast Year] as VaccYear <------- how do i move this to the previous table creation statement??

Resident ForecastTableTemp;

Drop table ForecastTableTemp;

Re: How to create field after load statement

tresB — Thu, 03 May 2018 09:03:48 GMT

Since VaccName is being created in crosstable statement, it can't be referred in the same load or even using preceding load statement. I.e. an additional load statement would be required.

Re: How to create field after load statement

bhaskar_sm — Thu, 03 May 2018 09:09:45 GMT

Hi,

you can use subroutine script control statement to jump from one section to another( PFB link for your reference).

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlStatements/Sub.htm

please correct me if i haven't understood your requirement.

if you found this helpful, please mark helpful or correct.

Regards,

Bhasker Kumar