Aggr Function with GetFieldSelection and Set Expression into Script Variable

[Anonymous]

Hi all,

I have an issue with the creation of a variable in the script part, however it seems to be problematic, hope somebody can have a quick look

This is my data

  t1

Id	Dim	Val
id1	a	5
id1	b	7
id1	c	19
id2	a	8
id2	b	10
id2	c	15

Another field called "DimSelect" used in the set analysis later and refered to by the GetFieldSelections expression is created by ->

Nav:

Load Distinct

     Dim as DimSelect

Resident t1;

Now, creating chart function works fine:

=aggr(max( {<Dim={'$(=GetfFeldSelections(DimSelect))'}>} Val), Id)

However, I would like to have this chart function as a variable created in the script, and unfortunately it does not work

Script:

let vAggr = 'aggr(max( { <Dim = {"$(=GetFieldSelections(DimSelect))" }> }  Val), Id)';

Chart:

=$(vAggr)

Does anyone possibly know what I am doing wrong? The issue seems to be with the expression GetfieldSelections(DimSelect), because inserting a value like "b" instead of GetFieldSelections expression also works fine.

Thanks!

[Anonymous]

Hello Marcus, thanks for the link, I will have a look

[Anonymous]

Hi Kiran, thanks for the link. I wanted to use the definition of it so that I can refer to it in the front end. I didn't want to use the script in any sort, as it depends on a front end action.