LOAD syntax

[sculptorlv]

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?

[jwjackso]

Try autogenerate

First TAB:

     DATA_BONUSS_KOEF:

     LOAD

      600 AS Agent_Salary_Constant_Part

   AutoGenerate(1)  ;

[hic]

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;

[sculptorlv]

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

[hic]

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,

     x / $(Agent_Salary_Constant_Part) as Ratio

     From <File> ;

[sculptorlv]

Ok. thank you very much!

I guess this will solve my problem!