Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

variables

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?

 

 

Labels (1)
10 Replies
Kush
MVP
MVP

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

raadwiptec
Creator II
Creator II

@Kush  in the Load script.. 

Kush
MVP
MVP

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

raadwiptec
Creator II
Creator II

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

raadwiptec
Creator II
Creator II

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

Usama
Creator
Creator

Yes, you can do in this way

 

From Nothing - To Something - To Everything
raadwiptec
Creator II
Creator II

 

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]));

Kush
MVP
MVP

@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
Creator II
Creator II

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