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: 
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.