Discussion board where members can get started with Qlik Sense.
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)