Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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"

Tags (2)
1 Reply
MVP
MVP

Hide a dimension column in a pivot chart or straight table

Hi plantm,

what is your problem / question?

Stefan

Community Browser