Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

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
Creator III
Creator III

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

View solution in original post

1 Reply
Creator III
Creator III

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

View solution in original post