Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
JWTA
Contributor
Contributor

URL expression with Dimension Variable in Script Variable

In URL/Expression window I have this (simplified url) and this works

 

='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]

 

I’m going to use this in 10+ places so like to put this in a Script variable

Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id

 

In Script

vEmpId ='[Employee Id]';

 

in the URL/Expression Window, the variable works

='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)

 

But when I tried to put that statement into the script format and I cannot figure out how to do it

 

varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);

varURL = ='http://mycompany.net/jump.ashx?employeeId=' &  chr(36) & (vEmpId);

 

Surprisingly I am getting a lot of

JWTA_0-1715101355098.png

Thanks in advance

 

Labels (2)
1 Reply
MatheusC
Specialist
Specialist

Will bring this to different places in the front-end view? Perhaps bringing it as a field might already be what you're looking for.

Table:

LOAD

     A

     B...,

     'http://mycompany.net/jump.ashx?employeeId=' & [Employee Id] as URL    

FROM [lib://] (qvd) ;


Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!