Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
matheus_silva
Contributor

Hide dimension in pivot table

Hi

There is some way to hide a dimension in a pivot table?

for example i have:

              7am     8am      9am     10am

'Sales'     x          y          z          r

and i want like this:

'Sales'     x          y          z          r

In other words, hide the second dimension...

Thank you!!

2 Replies
Highlighted
MVP
MVP

Re: Hide dimension in pivot table

You could custom format cell the header row, edit the text color, and set it to 100% transparency. The header row would still be there, but it wouldn't show anything. Not ideal, I guess.

Screen-background-colored text box overlaying the header row?

I feel like I'm missing something obvious, some "just checkmark this option".

Highlighted

Re: Hide dimension in pivot table

Hi,

In QlikView it was all about work-arounds so John's suggestion will only apply to QlikView.

QlikSense? Maybe by using Dual() and blank characters like 1=' ', 2='  ', 3='   ', 4='    ' etc.. then showing text value instead of number. I

have not tested it yet but i have got a feeling that QlikSense may trim them, so it can be back to square one!

Anyway - hope this helps

kind regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.