topic Re: Add line to Combo chart through macro in QlikView

Add line to Combo chart through macro

jixiaoquan — Thu, 23 Oct 2014 02:14:39 GMT

Hi ,

In qvw how to create a combo chart and add two expressions,one is bar,the other one is line?

In my QVW like this:

set chart = ActiveDocument.ActiveSheet.CreateBarChart

chart.AddDimension "ID"

chart.AddExpression "sum(Amount)"

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.BckAsBar = false

expr.BckAsLine = true

expr.BckAsSymbol= true

expr.ShowAsPopup = true

chart.SetProperties p

chart.AddExpression "sum(Amount)"

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ShowAsBar = true

chart.SetProperties p

It does not work,

Re: Add line to Combo chart through macro

Anonymous — Thu, 23 Oct 2014 08:12:51 GMT

Even i have a similar requirement to be achieved in my dashboard.Please help

Re: Add line to Combo chart through macro

tresB — Thu, 23 Oct 2014 10:30:36 GMT

Could you explain the situation better? Perhaps, the similar could be achieved using conditional expression in the chart. May be like in attached sample: