variables

[raadwiptec]

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?

[Kushal_Chawda]

@raadwiptec  do you want to refer in another load script of the another app?

[raadwiptec]

@Kushal_Chawda  in the Load script.. 

[Kushal_Chawda]

@raadwiptec  in  load script of same app or another app?

[raadwiptec]

@Kushal_Chawda  -- in the same app.. so i make a qvd out of first load script..then use that qvd as a fresh load 

[raadwiptec]

@Kushal_Chawda  -- in the same app.. so i make a qvd out of first load script..then use that qvd as a fresh load 

[Usama]

Yes, you can do in this way

[raadwiptec]

can you share the piece of code that we could reuse from the variable created.. For ex: here

SET vtest2 = Sum(AGGR(IF(Date(Monthstart,'DD/MM/YYYY') <= Date(Today(),'DD/MM/YYYY'),[sales]),[region]));

[Kushal_Chawda]

@raadwiptec  Not sure I am following that but as you already created a variable with code then you can call that variable in some other part of the code as purpose of the variable itself is to reuse the code.

[raadwiptec]

Iam able to reuse all the ones with LET Prefix, But SET Prefix iam getting some token error.