Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Highlighting Dimension in Table depending on Selection

Hi @all,

I'm trying to highlight dimension values based on a specific selection. The problem is that it only works for one selection, but not for two or more.

I hope these pictures illustrate, what I mean:

Unbenannt2.png

With one selected value it works. Axpo is highlighted correctly.

Unbenannt.png

But with two (or more) selected values it doesn't work.

The formula I use in the dimension expression of the table "Rankingtabelle" is:

=if(Sponsor_Sel>0 AND WildMatch(Sponsor_Conc, Sponsor)>0, RGB(255,0,0), RGB(0,0,0))

Sponsor_Sel: =GetSelectedCount(Sponsor)

Sponsor_Conc: =Concat(DISTINCT Sponsor, ';')

I hope anybody can help me! Thanks a lot in advance

Daniel

1 Solution

Accepted Solutions
Not applicable
Author

Hey,

ok, I figured it out. I thought too complicated. Just for you to know the correct expression should have been:

=if(not isnull(Sponsor) and GetSelectedCount(Sponsor)>0, RGB(x,x,x), RGB(y,y,y))

Everything works now!

View solution in original post

1 Reply
Not applicable
Author

Hey,

ok, I figured it out. I thought too complicated. Just for you to know the correct expression should have been:

=if(not isnull(Sponsor) and GetSelectedCount(Sponsor)>0, RGB(x,x,x), RGB(y,y,y))

Everything works now!