Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Atreyee_Dutta
Contributor
Contributor

How to define variable Global

Is this possible to define a variable globally to every report app in the repository so that I don't need to declare same variable in every report? I can define it within XLSX that I have tried but that XLSX file also needs to be identified with path location. I want to set that path location GLOBAL to every report app. Is this possible in Qliksense? Please help!!!
1 Solution

Accepted Solutions
Lauri
Specialist
Specialist

The typical way to do this is to store your variable in a text file and then use the Include function in the data load editor to bring it in. You'll need to add that Include statement to every app.

View solution in original post

3 Replies
Lauri
Specialist
Specialist

The typical way to do this is to store your variable in a text file and then use the Include function in the data load editor to bring it in. You'll need to add that Include statement to every app.

Atreyee_Dutta
Contributor
Contributor
Author

Thanks for the reply Lauri.. According to your solution I have included the file but this also seek for a path right.. which needs to declared in every app.

Though i want to run report without changing in every app, irrespective of environment. That's the reason I want to set connection string as Global Variable.

I have included below script :

LET vServerName=ComputerName();

If  vServerName='XXX' THEN 'PROD'...

Please help if there is anything such as Global Variable which can be declared once and can be utilized in every app.

 

Lauri
Specialist
Specialist

I haven't heard of such an option in Qlik Sense, though I agree it's a good idea! You should search the "Ideas" section of the forum to see if anyone has already proposed this. (Somewhat similar, you can see that Qlik is working on improvements in this area: https://community.qlik.com/t5/Ideas/Shared-master-library-between-apps/idi-p/1498195)