Hiding Dimension/Dimension values in pivot table

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

is it possible to hide a dimension as well as it's values, while still leaving the dimension "active" so your expressions are calculated accordingly?

I'm trying to overlay two pivot tables to accomplish having "Traffic Lights" as well as my actually expression values in the same cells in a pivot table (QT Should really add this functionality)

Here's a pic:

I've found out how to make the cells transparent so that I can overlay the lights with my values, but I'm not sure how to get rid of the Months that are above them, I don't want to have to hardcode in set analysis which values to represent... especially since there are going to be a lot of these lights on my report. I hope someone else has figured out how to do this.

Re: Hiding Dimension/Dimension values in pivot table

lucasdavis500 — Fri, 02 Dec 2016 18:19:05 GMT

SOLVED: Go to Dimension > click + button > Text Format > =ARGB(0,255,255,255) (white AND transparent), then for DIMENSION label do =CHR(10)

topic Re: Hiding Dimension/Dimension values in pivot table in QlikView

Hiding Dimension/Dimension values in pivot table

Re: Hiding Dimension/Dimension values in pivot table