topic Set Expression formula variable not resolving in App Development

Set Expression formula variable not resolving

Tos — Sat, 16 Nov 2024 20:41:04 GMT

Hi,

Set x = "=max(YR)";

Set y = num( round( Sum( {<YR={$(x)}, [fak]={1}>} [price]), 1), '#.##0');

I set these variables in a script. The problem is, when is enter this formula directly in a diagramm it works fine, but if i use the variable $(y) nothing happens. A look to the evaluated formula within Sense shows following:

num( round( Sum( {<YR={=max(YR)}, [fak]={1}>} [price]), 1), '#.##0');

But it should be:

num( round( Sum( {<YR={2019}, [fak]={1}>} [price]), 1), '#.##0');

I've already tried serveral combinations which i found in the qlik community, but nothing seems to work.

Does anyone know how to solve this issue? Or do i have to create the formulas with in the variable editor?

Thanks

Re: Set Expression formula variable not resolving

sunny_talwar — Wed, 12 Jun 2019 11:18:29 GMT

Look at the following threads to see the way to avoid dollar sign expansion in the script

Expression as a variable with $-sign expansion

Stop Dollar Sign Expansion in the script

Re: Set Expression formula variable not resolving

Tos — Wed, 12 Jun 2019 12:32:44 GMT

Answer 1:

LET variable = '= only({$<Sales={"' & '$' & '(#=max(Sales))"}>} Town)';

Answer 2:

set vTodayString = "~(Today());

set vToday = "=replace([vTodayString],'~','$')";

Both answers did it for me.

Thank you.