topic Re: Hiding values in a pivot table in QlikView

Hiding values in a pivot table

Fri, 17 May 2013 12:41:03 GMT

Hi -

Is it possible to hide scpecific values in a pivot table? For example:

Dim 1

Red -----------> Show

Yellow -------> Exclude from the pivot table

Greeen ------>Show

Thank you!

Fri, 17 May 2013 13:19:47 GMT

i don't remember exactly(sorry) but it does exists the possibility to unactivate a expression

if (Value = Yellow, <unactivate>)

This has the same effect as tick/untick the "Activate" box in Expression Tab

Chris