topic Re: Tablename help? in QlikView

Tablename help?

Wed, 29 Oct 2014 12:50:26 GMT

Hi,

In script i have like this

in 1st Tab i have script like this

LET vTime=now(1);
LET vTableName = 'Employee';

[$(vTableName)]:
lOAD * from
table1;

in 2nd tab i have script like this

LET vTime=now(1);
LET vTableName = 'Sales';

[$(vTableName)]:
Load * from Table2;

Here in 2 tabs the (vTablename) variable name same.in the 1st tab this variable place the value 'Employee' and in 2nd tab with Sales.how it is possible.here we have 2 different values for 1 variable.

Please explain?

Re: Tablename help?

Wed, 29 Oct 2014 12:51:53 GMT

it will take separately for each tab

Re: Tablename help?

danieloberbilli — Wed, 29 Oct 2014 12:53:37 GMT

the script runs consecutively - first the variable is filled with Employee and afterwards overwritten with Sales

Re: Tablename help?

alexandros17 — Wed, 29 Oct 2014 12:53:53 GMT

your variable has 2 LET instructions, so in different moment it has 2 values assigned statically to tables (TAbles name are not linked to variable but only managed by it).

If you see the value of your variable it returns 'Sales' because it is the last value assigned