topic Macro to add condition to expression in QlikView

Macro to add condition to expression

Thu, 27 Oct 2011 10:28:17 GMT

Hello all,

I was wondering if there is any kind of way that will allow me to add a condition to expressions through macros. At the moment I have a macro that dynamically adds expressions to a chart and I want to make sure the expressions are alwys greater than zero. Otherwise they shouldn't apper in the graph. Looking at the API the only thing I found was EvaluationCondition command, which only applies to table objects though. Any ideas?

Macro to add condition to expression

Fri, 28 Oct 2011 08:47:21 GMT

So doesn't anyone have any clue about this? I'd be surprised if there is no way to programmatically insert conditions for expressions.

Re: Macro to add condition to expression

IAMDV — Thu, 28 Aug 2014 15:48:09 GMT

Hi,

I know this is very old thread but have you got around a way to add conditional expressions using VB Script?

Thanks,

Re: Macro to add condition to expression

marcus_sommer — Thu, 28 Aug 2014 15:54:27 GMT

Have a look here: Macro for Conditional expression in chart

- Marcus

Re: Macro to add condition to expression

long_huynh — Sun, 27 May 2018 21:25:40 GMT

Recognise that this is quite an old thread but the answer is found in bold and underlined in the example code below:

set chart = ActiveDocument.ActiveSheet.CreateStraightTable

chart.AddDimension "Customer"

chart.AddExpression "sum(Amount)"

set cp = chart.GetProperties

set expr = cp.Expressions.Item(0).Item(0).Data.EnableCondition

expr.Type = 2

expr.Expression = "Sum(Amount)> 500"

chart.SetProperties cp

You first need to enable the tick the conditional option type (=2) then add the expression (you conditional expression).

Thanks,

Long