topic hiding the column in QlikView

hiding the column

Wed, 13 Oct 2010 10:19:47 GMT

Hi,

Is it possible to hide the dimesnion in the Piviot or the straight table?

I have created a piviot/straight table with dimension A,B and expresssion is avg of c. So the expression is group by of B,A. Here i would like to hide the column b. But it should not have any impact on the result of expression it should work in a such a way that group by B,A

hiding the column

nathanfurby — Wed, 13 Oct 2010 10:55:56 GMT

I think you should post an example.

hiding the column

wizardo — Wed, 13 Oct 2010 10:56:02 GMT

hi xxx

in a straight table you can go to the presentation tab in the properties, there you can show/hide all columns(dimensions and expressions).

you can even use a condition.

in a pivot table the only way to hide is to collapse a dimension. and you cannot hide the expressions, just disable them.

Mansyno

hiding the column

Wed, 13 Oct 2010 14:25:09 GMT

Hi,

I think that you use a two dimension for only group the values of your expression.

You can use the function "AGGR" to do this and you use only one dimension.