topic Re: Delay Dollar Sign Expand in User Defined Function in App Development

Delay Dollar Sign Expand in User Defined Function

pedrohenriqueperna — Thu, 22 Jan 2026 02:25:22 GMT

Hi,

I'm trying to create defined functions to make some expressions more readable, but I can't find a workaround to not expand a $() using SET.

For instance:

SET someFunction = (Sum(Aggr({<store= {$1}>} Revenue, store)) / Aggr(NoDistinct Only({1<key_calendar = {"$(=Floor(vToday - 1))"}, store = {$1}>} growth_idx), store));

When this function is loaded, it expands the set analysis "$(=Floor...)" and returns blank, as expected. Is there a way to delay the expansion to the front end? I've tried multiple things, like using Chr(34) for the " and Chr(36) for the $. They all come as text tho.

Re: Delay Dollar Sign Expand in User Defined Function

Vegar — Thu, 22 Jan 2026 06:05:10 GMT

The best workaround for this, that i know, is to create a csv, excel file or similar containing the variable name and value. Then load that table into Qlik, and loop through each row and setting the variable name and expression using peek().

I did a quick search to find an example, you could look this comment by @rwunderlich : https://community.qlik.com/t5/App-Development/Can-I-create-a-variable-that-holds-another-variable/td-p/2519136#M106193

Re: Delay Dollar Sign Expand in User Defined Function

pedrohenriqueperna — Thu, 22 Jan 2026 19:12:55 GMT

Hi, thanks for the reply

Although far from practical, it works, thanks!!

Re: Delay Dollar Sign Expand in User Defined Function

pedrohenriqueperna — Thu, 22 Jan 2026 19:24:59 GMT

Can you give me an example based on the code I've provided?

I've tried like this, but it did not work:

SET func$ = $; SET someFunction = (Sum(Aggr({<store= {$1}>} Revenue, store)) / Aggr(NoDistinct Only({1<key_calendar = {"$(func$)(=Floor(vToday - 1))"}, store = {$1}>} growth_idx), store));