topic Re: Hide the Dimention in a Pivot Table in QlikView

Hide the Dimention in a Pivot Table

Tue, 11 Oct 2011 05:51:14 GMT

Good Morning All,

In a Pivot table, is it possible to hide the dimention( "Location Name"), I need to display only the Number of Invoices and Sales Expression.

Location Name	Number of Invoices	Sales
Test1	500	5211111
Test2	235	7855444
Test3	562	4785555

I would like to hide the Location Name.

Regards

Joe

Re: Hide the Dimention in a Pivot Table

SunilChauhan — Tue, 11 Oct 2011 06:45:20 GMT

see the attached file

hope this help

Re: Hide the Dimention in a Pivot Table

Tue, 11 Oct 2011 06:46:16 GMT

Hi, If you want to hide a column, go to Presentation tab in the chart properties windows which can be opened by right clicking your pivot table and clicking the Properties, and select the column, and select the radio button Hide Column.

If you want to hide an expression from your pivot table, you can uncheck the Enable check box by selecting an unwanted expression from the Expressions tab in the chart properties windows which can be opened by right clicking your pivot table and clicking the Properties.

I hope this will help you to do that.

Re: Hide the Dimention in a Pivot Table

Sokkorn — Tue, 11 Oct 2011 07:10:42 GMT

Hi Joe,

I think this one is not available yet in Pivot Tables. But we still can do it with these solution:

1. Use a text color Dimensions to make the text same color as backgound.

2. Macro:

SUB HideDimension

SET ch = ActiveDocument.GetSheetObject("CH01")

ch.SetPixWidth 0, 0

END SUB

Hope this help.

Regards,

Sokkorn

Re: Hide the Dimention in a Pivot Table

vincent_ardiet — Tue, 11 Oct 2011 07:16:49 GMT

Hi,

Instead of changing the color, you can, in the dimension properties, use the "advanced..." button and choose an "image" representation and check "Hide text when image is missing".

And of course, force the label of the dimension to a single space.

Regards,

Vincent

Re: Hide the Dimention in a Pivot Table

Tue, 11 Oct 2011 07:34:45 GMT

Dear All,

Thanks a lot, your examples helped me lot...

Regards

Joe