Customized highlight text in pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

City	Population
Mumbai	1500000
Pune	1600000
Chennai	1260000
Hydrabad	1556000
Bangalore	1500056

Re: Customized highlight text in pivot table

avkeep01 — Fri, 01 Dec 2017 10:18:18 GMT

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.

topic Customized highlight text in pivot table in QlikView

Customized highlight text in pivot table

Re: Customized highlight text in pivot table