Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

udaya_kumar
Valued Contributor

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?

Tags (1)
1 Solution

Accepted Solutions
udaya_kumar
Valued Contributor

Change the selected row color as green in pivot table

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.

1 Reply
udaya_kumar
Valued Contributor

Change the selected row color as green in pivot table

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.

Community Browser