topic Re: Hide dimension from pivot table, but keep its grouping in QlikView

Hide dimension from pivot table, but keep its grouping

d_petrov — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have pivot table with 3 dimensions and one expression.

One of the dimensions is moved at the top of t he expression with the help of the blue arrow.

Is it possible to hide the values of the 2 dimensions, but keeping their grouping?

Best regards,

D. Petrov

sunny_talwar — Fri, 14 Jun 2019 12:19:31 GMT

May be use a one time Macro to shrink the width of the column to 0

d_petrov — Fri, 14 Jun 2019 12:30:47 GMT

Thank you Sunny,

It worked for me!
🙂

Best Regards,
D. Petrov

d_petrov — Mon, 17 Jun 2019 13:02:07 GMT

Hello Sunny,

Do you know how to hide a dimension used at the top - hide row?

Best regards,

D. Petrov

sunny_talwar — Mon, 17 Jun 2019 13:04:42 GMT

I have not done this before, I don't know if this is possible or not.