Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
lucasdavis500
Contributor II

Hiding Dimension/Dimension values in pivot table

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:

pivot.png

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.

1 Solution

Accepted Solutions
lucasdavis500
Contributor II

Re: Hiding Dimension/Dimension values in pivot table

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

pivot.png

1 Reply
lucasdavis500
Contributor II

Re: Hiding Dimension/Dimension values in pivot table

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

pivot.png