topic Re: Highlight multiple values in pivot without removing the other values in the same pivot in QlikView

Highlight multiple values in pivot without removing the other values in the same pivot

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

Is there any option to be able to highlight multiple values in single pivot table without removing other values of the same pivot?

Re: Highlight multiple values in pivot without removing the other values in the same pivot

devarasu07 — Wed, 29 Nov 2017 17:09:00 GMT

Hi,

it's not clear, can you share some mock data and expected output in excel format. it will easy for us to help u.

Uploading a Sample

Re: Highlight multiple values in pivot without removing the other values in the same pivot

trdandamudi — Wed, 29 Nov 2017 19:10:33 GMT

One way is as below:

Re: Highlight multiple values in pivot without removing the other values in the same pivot

Anonymous — Thu, 30 Nov 2017 13:53:10 GMT

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

e.g.

City

Mumbai

Pune

Chennai

Hydrabad

Bangalore

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

Re: Highlight multiple values in pivot without removing the other values in the same pivot

Anonymous — Fri, 29 Dec 2017 09:35:41 GMT

I have pivot table which has city and population field. Now when user select Mumbai or Hydrabad then these 2 values gets highlighted along with retaining other values in same table. And the selection of values will be the user's choice.

Please find below example for your reference.

I hope this helps.

e.g.

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

Re: Highlight multiple values in pivot without removing the other values in the same pivot

devarasu07 — Fri, 29 Dec 2017 10:17:05 GMT

Hi,

do u want this color by user filter selection? or it just static then u can try like below

=if(match(City,'Hydrabad','Mumbai'),RGB(255,0,0),Black())

p.s; just add above code in your City dimension & measure as text color expression then u can get below o/p

another way u can add data island at back check this method

Dynamic colors in QlikView – Learn QlikView

Thanks,Deva

Re: Highlight multiple values in pivot without removing the other values in the same pivot

Anonymous — Fri, 29 Dec 2017 10:27:51 GMT

Hi Deva,

Thanks for the response.

I don't want filter for city. I just wanted to use pivot table where user has access to highlight city/population.

Looking forward for your kind response.

Thanks,

Swati

Re: Highlight multiple values in pivot without removing the other values in the same pivot

sasikanth — Fri, 29 Dec 2017 11:14:27 GMT

Hi Swati,

Please add the below expression to both DIMENSION, EXPRESSION --> Text color expression

= If(Wildmatch(Concat(DISTINCT(City), '|'), City ) and GetSelectedCount(City)>0, Red(),black())

Note : Please add the dimension filed to your expression using set analysis

Ex: sum({<City={'*'}>}sales)

Thanks

Sasi