Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I 'd like the window title of a chart to display the users selection of a small dimension. So, if the user select serveral elemens out of the dimension all of them should be displayed in the window title.
I know, usually this kind of requirements are implemented by the use of a "Current Selection Box" but this might not be an option here.
Thx
Ludwig
I've added my solution to nmartin example.
(I've learned something today with the concat function 🙂 )
Both solutions work,
differences are :
when no selections are made :
- if you want to list all possible values => use the concat version
- if you want to display another thing => you can use the getfieldselections
on big selections :
- possibilities to display a ratio ( x values on y) with the getfieldselections
Regards
YOu can Specify the Field Name
eg :
= 'Customer Name is ' & CUSTOMERNAME
where CUSTOMERNAME is the field name.
You can use an expression like this for your Windows title :
=if (GetSelectedCount(MY_SMALL_DIMENSION), ' Selections on my small dimension are' & GetFieldSelections(MY_SMALL_DIMENSION,', ',50) , 'String to display when there are no selections')
where MY_SMALL_DIMENSION is the name of your dimension, ',' is the string to display between two field selections, and 50 is the max number of items displays. for example if I've selected 51 items in my dimension and there are 2500 existing distinct values in this dimension, it will displays '51 of 2500 values' instead of the list of available items.
Best regards
= 'Customer Name is ' & CUSTOMERNAME
will display a "-" if more than 1 CUSTOMERNAME is selected.
Use
= 'Customer Name : ' & concat(CUSTOMERNAME, ', ')
instead.
[EDIT]
Bertrand gave another good (proper) solution at the same time. 🙂
[/EDIT]
I've added my solution to nmartin example.
(I've learned something today with the concat function 🙂 )
Both solutions work,
differences are :
when no selections are made :
- if you want to list all possible values => use the concat version
- if you want to display another thing => you can use the getfieldselections
on big selections :
- possibilities to display a ratio ( x values on y) with the getfieldselections
Regards