Difference between using Variables in the Loadscript Sencse vs. View

[MartinGer]

In the good old times, i used the following part of a Script to load dynamic columns from a table with QlikView.

Table1:

Table1:
LOAD 
   %ArtikelNr_PK,
   $(VAR_DATE_Year_Current)		as AY,		
FROM c:\Example\test.qvd (qvd);

and it works perfekt. 

Result:

%ArtikelNr_PK	AY
A	10
B	15
C	30
..

Now if I use the same Script in QlikSence. I get now a wrong result. Now i have always the value of the variable in each cell.

Result:

%ArtikelNr_PK	AY
A	2020
B	2020
C	2020
..

I have no Idea whats wrong ?

sincerly Martin

[martinpohl]

for me it look ok.

You have one variable so you have one value in all data lines.

How are the values 10, 15, 30 a.s.o in QlikView script calculated?

What is the value or expression in variable?

Regards

Martin

[marcus_sommer · Accepted solution]

You mean your variable won't be interpreted as field else it just takes it as field-value? You could try to add brackets like:

[$(VAR_DATE_Year_Current)] as AY

- Marcus

[MartinGer]

Thanks Marcus,

thats what I want to know. For me thats new. But it works !

sinceryl Martin