Pass variable value too measure expression

[eheyrman]

I set a function and a variable containing values as such:

SET vFracAggrAvg = fractile(aggr((avg({$<$3={$4}>}$1)),$2),$5);

SET vPercentiles = 0.05,0.10,0.15,0.20,0.25,0.30,0.35,0.40,0.45,0.50,0.55,0.60,0.65,0.70,0.75,0.80,0.85,0.90,0.95;

Now I created a table with

=Valuelist($(vPercentiles))

as dimension column to get one of the variable values per row. 

In a second column I set 

=$(vFracAggrAvg(BD100,Beslag,[Reg Maand.autoCalendar.YearsAgo],3,Valuelist($(vPercentiles))))

as measure, hoping to get in each row the calculated value for the corresponding variable value as $5 parameter.

This doesn't work as expected however and I just get gray cells with a '-':

Anyone know how I could get the desired result?

[Filippo_Nicolussi_P · Accepted solution]

Hello Evert

Based on the help https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/dollar-sig...  vFracAggrAvg  needs to be evaluated as expression inside the chart, rather than the let x = ...  in the "Dollar-sign expansion using parameters" you should try the "Dollar-sign expansion using an expression"  =$(=vFracAggrAvg(BD100,Beslag,[Reg Maand.autoCalendar.YearsAgo],3,Valuelist($(vPercentiles)))) .