topic Re: Pivot cell highlight ? in QlikView

Pivot cell highlight ?

gerrycastellino — Tue, 25 Nov 2014 18:15:57 GMT

Is there a way to highlight a cell in a pivot chart once you click into that cell ? as indicated below ?

Re: Pivot cell highlight ?

ashfaq_haseeb — Tue, 25 Nov 2014 18:35:50 GMT

Hi,

Yes possible

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Have a look at below post too

Re: custom row colors in pivot table

Regards

ASHFAQ

Re: Pivot cell highlight ?

JonnyPoole — Tue, 25 Nov 2014 18:38:23 GMT

I did get a sample working for this . There are two pieces needed. One expected, one not so much

1. (expected) background color expression on the cell to check if a drill has occurred and which selection was made

if(

(

GetSelectedCount(Year)>0

and

GetSelectedCount(REGION)>0

)

and

(

SubStringCount( Concat(DISTINCT total REGION),REGION)>0

and

SubStringCount( Concat(DISTINCT total Year),Year)>0

)

, LightGreen())

2. ( a little unexpected): I used SET ANALYSIS to ensure that all values still show after the selection, but it causes some inconsistent selection behavior. The solution was to multiply by an aggregation function that does not use SET ANALYIS but also does not change the result:

sum( {<REGION=,Year=>} Sales)

(sum( Sales-Sales)+1)

Re: Pivot cell highlight ?

gerrycastellino — Wed, 26 Nov 2014 19:40:00 GMT

Jonathan:

a good start Thank You !, But I'm running into issues.

I added the variable as you created, and have my new sheet created.

However when I click on a cell in the pivot, QV seems to be crashing with the image you see.

Gerry