How to retrieve the possible values of a dimension in a text box?

[OmarBenSalem]

Hi Folks,

The thread's title is maybe not that clear; but let me explain what I'm seeking to do:

For example: I have 2 dimensions: num and nom

What I want to do: is when I select num=1; I want to display in a text object nom:x,y ; how to do so?

I've tried with : aggr(only({<nom=p(nom)>}nom),nom)

But, that did not work; any idea?

[ali_hijazi · Accepted solution]

you can use concat function as follows:

='nom:' & concat(distinct nom,',')

[OmarBenSalem]

Sorry to bother you; just found it

='The associated nom : '& concat(distinct aggr(only({<nom=p(nom)>}nom),nom),',')

Result:

[OmarBenSalem]

Much easier ! Don't know why this did not work with another application though; yet It works with this case..

Thank u anyway !

[OmarBenSalem]

We could also change it as follow to retrieve the associations by nom and num; I mean :

= concat(distinct num&':'&nom,', ')

[OmarBenSalem]

What if I wanted to show : 1:x,y 2:a 3:b ?