Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

find in a straigth table a selected dimension

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

4 Replies
Not applicable
Author

any idea ?

pover
Partner - Master
Partner - Master

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.

Not applicable
Author

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

pover
Partner - Master
Partner - Master

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.