Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I cant' figure out this issue.
I have an application with a lot of charts.
One of them is a straigth table which is independant of the selection. The dimension of this table is CITY.
A user have to select in a list box a CITY.
My objective is to color or highligth in the table the selected CITY to find easily where is the selected CITY.
Maybe I have to use the background color of the dimension but I don't know how.
Thanks for any help
JJJ
any idea ?
Try putting the expression
=if(match(MonthYear,$(Selected_MonthYear)),lightgreen())
in the background color of the dimension and in the variable Selected_MonthYear I put
=chr(39)&getfieldselections (MonthYear,chr(39)&','&chr(39))&chr(39)
The example is attached. I hope that is what you were looking for.
Regards.
Thanks Karl it works well !!
I still don't understand the expression =chr(39)&getfieldselections (MonthYear,chr(39)&','&chr(39))&chr(39)
even it works.
regards
jjj
Maybe with all the chr(39) it looks confusing, but it is just so you can create a list with singles quotes like 'Ene','Feb','Mar'. The getfieldselections returns a list of values and I want to declare my separator as a ',' but if a put ',' the expression will think I just want a , without quotes so I have to put chr(39)&','&chr(39) to get ',' and then I need a singel quote at the beginning and end or the list.
In that way you can form a dynamic match that in this case ends up being
match(Month,'Ene','Feb','Mar')
because match(Month,Ene,Feb,Mar) doesn't work.
I'm glad it works.