Change URL link depending on login environment

[jmialoundama]

Hello,

I want to change the url link of a board based on my login:

I have an Integration connection and an ODBC connection for data in Production.

When I am in integration my URL link is the following:
https://int-test-data/cars/index.php?=controller=....

When I am in production the URL link is the following:
https://prod-data/cars/index.php?=controller=....

How can I do in my Qlik Sense application to put the right URL link according to the ODBC connection I am on.

Thank you in advance for your help

[Qlik_Eric_Thomas]

Maybe something combining the if() control statement with the ComputerName() Function?

Something like:

IF(wildmatch(ComputerName(),<Your Prod Server Name>),'<prod URL>','<int URL>')

You can use the ComputerName() Function in a KPI on each environment to verify what the value will look like

[jmialoundama · Accepted solution]

Hi @Qlik_Eric_Thomas ,

Thanks you for your feedback. 

I create this  little script to solve my problem : 

/*We come to retrieve the name of Qlik Sense server*/
LET v_Project_Environnement = IF(ComputerName()='name_of_server', 'INTEGRATION', 'PROD');

/*URL integration*/
LET v_Serveur_INT = 'URL_INTEGRATION';

/*URL Production*/
LET v_Serveur_PROD = 'URL_PRODUCTION';

LET v_URL_Path = IF('$(v_Project_Environnement)'='INTEGRATION', '$(v_Serveur_INT)', '$(v_Serveur_PROD)');

TRACE 'l_urlPath=$(l_urlPath)';