Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rajtechnocraft
New Contributor III

Hiding of dimension in pivot table

Hia all,

I have created a pivot table and in that i have used one calculated dimesion for filtering purpose.

What i want is i should not display that dimension in report but its importance is for filtering the results.

How can i hide a dimension in a pivot table.

Can you guys help me in this

I went through api guide.qvw but couldn't find the macro

Tags (2)
3 Replies
MVP
MVP

Hiding of dimension in pivot table

You can use a Group of Dimensions which shows only the one you want to show in the chart/pivot table, but use it later in reports, or you can add a if statement to say when and how you want to show that dimension, if that's what you want.

Not applicable

Hiding of dimension in pivot table

Hi

Just to be clear, I think an IF statement to conditionally show a dimension is only available in Version 9.

I don't know of a way in version 8.x to conditionally show a dimension on a pivot table or even to have it functioning but not showing, it can be done very simply on a straight table in the presentation tab.

One option might be: Change the text colour to white and make the column size very small but you'd need to check what the impact of this is on the report as I don't ever use reports in QlikView.

MVP
MVP

Hiding of dimension in pivot table

Hello Nigel,

You are right. We all should indicate the version of QV we are working with, as I never used version 8.x so I don't know how many changes and which changes are from one version to another. And sorry for the inconvenience. For what is worth, I'm using QV v9.00 SR1

Regards.

Community Browser