topic Qlikview - Edit Background Color for All Expressions at Once in QlikView

Qlikview - Edit Background Color for All Expressions at Once

Thu, 05 Oct 2017 17:57:34 GMT

My dashboard has 40 sheets, each with its own pivot table including 10-30 expressions per pivot table. I am trying to do a mass color edit. Is it possible to loop through all of these with a macro do change the color background for each expression? The goal is to get the subtotals in all pivot tables to be a particular color.

I am currently using this function in the color background under expressions.

IF(ColumnNo() = 0,

RGB(141, 180, 226))

Re: Qlikview - Edit Background Color for All Expressions at Once

m_woolf — Thu, 05 Oct 2017 19:23:58 GMT

This thread contains a macro that colors the backgrounds of all dimensions in a chart. Maybe you can modify it for expressions. You would need to add a loop to get all charts instead of just the one.

Re: Qlikview - Edit Background Color for All Expressions at Once

Thu, 05 Oct 2017 19:28:23 GMT

I already solved it.

Sub ChangeColors

set allValues = ActiveDocument.Fields("Variable").GetPossibleValues

msgbox allValues.Count

For i=6 to allValues.Count-1

set testing = ActiveDocument.GetSheetObject(allValues.Item(i).Text + " Pivot").GetProperties.Expressions '.Item(0).Data.ExpressionDat

msgbox allValues.Item(i).Text + " Pivot"

expressionCount = testing.count - 1

For iteration = 0 to expressionCount

testing.Item(iteration).Item(0).Data.AttributeExpressions.BkgColorExp.Definition.v = "$(Subtotal_Blue)" ' $(Subtotal_Blue)= IF(ColumnNo() = 0, RGB(141, 180, 226)

ActiveDocument.GetSheetObject(allValues.Item(i).Text + " Pivot").SetProperties testing