Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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'