Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
swatikharbas
New Contributor

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
Tags (1)
1 Reply
Highlighted
Partner
Partner

Re: Customized highlight text in pivot table

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.