topic Re: LOAD syntax in QlikView

LOAD syntax

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

Please help me with the syntax .. I have strange (for me) situation.

I have to TABs in Qlikview Edit script.

First TAB:

DATA_BONUSS_KOEF:

LOAD

600 AS Agent_Salary_Constant_Part

;

Second TAB:

DATA_LOAD_AGENTS_BUDGET:

SQL SELECT

TABLE_AGENT_AND_BUDGET.Amount AS Budget_Money

FROM "XXX$XXX Item Budget" AS TABLE_AGENT_AND_BUDGET

;

As the result I got NOTHING. If I will remove the first TAB, then the second TAB will give me Budget_Money values.

What do I do wrong?

Re: LOAD syntax

jwjackso — Wed, 28 Feb 2018 11:28:01 GMT

Try autogenerate

First TAB:

DATA_BONUSS_KOEF:

LOAD

600 AS Agent_Salary_Constant_Part

AutoGenerate(1) ;

Re: LOAD syntax

hic — Wed, 28 Feb 2018 13:25:31 GMT

What do you want the first Load statement to do? If you just want it to be a constant that you can use everywhere, then you should store it as a variable, and not as a table:

Set Agent_Salary_Constant_Part = 600;

Re: LOAD syntax

sculptorlv — Wed, 28 Feb 2018 13:29:27 GMT

I wan in the very begging put all the variables (you ar correct),

but later I want to use these variables (within the edit scrip section with LOAD) to make changes in tables data with LOAD

Re: LOAD syntax

hic — Wed, 28 Feb 2018 13:32:54 GMT

Still, if there is only one value of Agent_Salary_Constant_Part then it should be a variable. You can then use the variable in the Load statement like

Load

x / $(Agent_Salary_Constant_Part) as Ratio

From <File> ;

Re: LOAD syntax

sculptorlv — Wed, 28 Feb 2018 13:36:15 GMT

Ok. thank you very much!

I guess this will solve my problem!