Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide a dimension column in a pivot chart or straight table

''Hide a dimension in pivot chart or straight table

''Define the following variable vShowCustomers via the script.

''SET vShowCustomers = 'Hide';

''Create Input Field to toggle vShowCustomers variable values between 'Hide' and 'Show'.

''Create the following macro. 

''I found this macro on QV community at http://community.qlik.com/message/37992#37992.

''Dimension index starts at '0'...

sub mToggleCustomers

set var = ActiveDocument.Variables("vShowCustomers")

varValue = var.GetContent.String

set obj = ActiveDocument.GetSheetObject("CH26")

set objProp = obj.GetProperties

set objDim = objProp.Dimensions

if varValue = "Hide" then

objDim(1).ColWidth = 0

var.SetContent 0,true

else

objDim(1).ColWidth = 1000

var.SetContent 1, true

end if

obj.SetProperties objProp

end sub

''Create an OnChange Variable Event Trigger within document properties for varable vShowCustomers.

''This event will run macro 'mToggleCustomers

''Within the Chart Properties, define the dimension with the variable condition.

''Make sure the else is a ' ', not a ''...

''=if(vShowCustomers = 'Show', Ship_to_Customer_Name, ' ')

''Within the Chart Properties-->Presentation tab, set a conditional show on the dimension

''vShowCustomers = 'Show'

''Within the Chart Properties-->Presentation tab, set chart to "Always Fully Expanded"

1 Reply
swuehl
MVP
MVP

Hi plantm,

what is your problem / question?

Stefan