Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dollar sign expansion within a dollar sign expansion

Hi All

Is it possible to do a dollar sign expansion within a dollar sign expansion?

for example, I have:

set convertdate = Date#(Date($1));

set converttime = Time#(Time($1));

set maketimestamp = timestamp(date#(date($1)) + time#(time($2)));

is it possible to do this?  set maketimestamp = timestamp($(convertdate($1)) + $(converttime($2)));

when I try, it seems to get stuck and the script never finishes loading?

1 Reply
Not applicable
Author

Yes it is possible. Try it with a simple example in your script:

  1. Open Variable Overview (CTRL+ALT+V)
  2. Create variable: vHello = 'Hello ' & $1 & '.'
  3. Create variable: vFood = $(vHello($1)) & ' I like ' & $2 & '.'
  4. Click OK to close Variable Overview
  5. Create a Text box and set text to: =$(vFood('Jack', 'Pizza'))

The text box will display 'Hello Jack. I like Pizza'