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: 
Anonymous
Not applicable

Customized highlight text in pivot table

Can anyone help me on below scenario?

I have one filter of field which is used in pivot table and when user select the values in the filter then pivot should display the selected values as highlighted and also retain non selected values in the same pivot.

e.g.

 

   

City
Mumbai
Pune
Chennai
Hydrabad
Bangalore

 

   

CityPopulation
Mumbai1500000
Pune1600000
Chennai1260000
Hydrabad1556000
Bangalore1500056
1 Reply
avkeep01
Partner - Specialist
Partner - Specialist

Hi Swati Kharbas,

This is a cool one. You need to do 2 things;

1. Set your expression with the help of set analysis

Your dimension is City so your expression should ignore that (otherwise only the selected values are shown)

SUM({$<City=>}Population

2. Set your color codes:

The expression for your color should react on the selections. I mostly use

IF ONLY(City) = ONLY({1}, RED(),BLACK()).

Because City is the dimension it also works with multiple cities selected because it looks at every row. Then it compares this selected cities to all the cities. With {1} all selection are ignored.