Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have used a calculated variable as below and i have stored this along with rest of the data load into a qvd
SET vtest2 = Sum(AGGR(IF(Date(Monthstart,'DD/MM/YYYY') <= Date(Today(),'DD/MM/YYYY'),[sales]),[region]));
Now i would like to refer this variable again in another load script.. to use the result of above variable.
is this possible?
For ex: is i try like this it gives me token errors
LOAD
Reference",
salestype
"Monthstart",
$(vtest2)
FROM [lib://User Mappings/Qvd/final.qvd](qvd)