How to disable a specific column from selection in Pivot table

[#1]

Hi All,

Currently I can make selection across the dimensions in the attached pivot table: Organisation, Business Group, Business Unit, Product

However, I want to disable the selection of ‘product’ in the privot table. Any ideal how this can be configured?

Many Thanks!

Heok

[#2]

Maybe you can try using this set analysis in all your expressions : {<keyProduct2=>}

This will ignore the selection in product.

It is harder to prevent qlikview from making a selection.

regards

stephane

[#3]

I tried that and it doesn't seems to work for my purpose.

Thanks anyway!

[bbi_mba_76]

Hi,

if you could have the always fully expanded option, then you can put a transparent text over the field.

[rustyfishbones · Accepted solution]

Create a Text Object set the color to transparent and cover the product

see attached

[#6]

This is a good idea to workaround. Thanks All!