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: 
udaya_kumar
Specialist
Specialist

Change the selected row color as green in pivot table

Hi,

i have a pivot table with data, when we select some row, then that row should be highlighted with some color.

i tried it with background color property in table for dimension and expression, its not working.

so how we can do that?

1 Solution

Accepted Solutions
udaya_kumar
Specialist
Specialist
Author

hello experts,

i did it by using the expression

=if(wildmatch(GetFieldSelections([trend.Product],',',100),'*'&only({1} [trend.Product])&'*' ),RGB(255,0,0))

it works fine,

put this in background color property for dimension and expression.

View solution in original post

1 Reply
udaya_kumar
Specialist
Specialist
Author

hello experts,

i did it by using the expression

=if(wildmatch(GetFieldSelections([trend.Product],',',100),'*'&only({1} [trend.Product])&'*' ),RGB(255,0,0))

it works fine,

put this in background color property for dimension and expression.