topic Hiding a dimension in Pivot Table in QlikView

Hiding a dimension in Pivot Table

Fri, 29 Jul 2011 13:34:40 GMT

Is it possible to hide a dimension in Pivot Table?

Thanks in advante,

Lucas

SunilChauhan — Fri, 29 Jul 2011 13:41:46 GMT

in pivot its not possible. but u can hide in straight table.

properties-->Presentation->select dimension---> check radio button

and see ur result..

Fri, 29 Jul 2011 13:46:17 GMT

hi Lucas

we can also hide the column in straight table based on condition.

Fri, 29 Jul 2011 13:59:25 GMT

Thanks, but i really need this in pivot table.

Fri, 29 Jul 2011 14:10:43 GMT

Hi,

Do you need the dimension just for to calculate your expression?

Maybe you can use the function AGGR() in your expression and don't need more the dimension that you want to hide.

Fri, 29 Jul 2011 14:38:06 GMT

hi,

one more thing you can do with pivot table. just show your calculation in expression and drag the expression column to dimession level.

sumit