Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

Highlighted
Creator II
Creator II

@Kush  in the Load script.. 

Highlighted
MVP
MVP

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

Highlighted
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 

Highlighted
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 

Highlighted
Creator
Creator

Yes, you can do in this way

 

From Nothing - To Something - To Everything
Highlighted
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]));

Highlighted
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.

Highlighted
Creator II
Creator II

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