How to define variable Global

[Atreyee_Dutta]

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!!!

[Lauri · Accepted solution]

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]

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]

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)