topic How does Conditional option in expression tab works? in QlikView

How does Conditional option in expression tab works?

Hatus — Fri, 08 Jun 2012 13:21:21 GMT

I would like to understand how the option in the Expression tab "Conditional" works. It is a new feature in QV11, can someone help me?

Thank you

How does Conditional option in expression tab works?

swuehl — Fri, 08 Jun 2012 15:49:15 GMT

This feature can be used to conditionally enable the expression.

Check out the What's New in QlikView11 demo app (e.g. download from the QV demo site), on report tab, there is a demo of that feature (and looking at the expression used in the conditional field, it should be easy to understand).

Hope this helps,

Stefan

Re: How does Conditional option in expression tab works?

Hatus — Thu, 14 Jun 2012 10:25:47 GMT

Thanks for the advice. Can you use the Expression Calculation Condition to manipulate the calculation order?

Like:

Expression_1

sum(Sales)

//no Contidions

Expression_2

sum(costs)

Condition: Expression_1>0

Or Condition: Column(1) >0

That would help me to create a Chart with very complex Expressions. The condition should not recalculate the Expression_1 again

Like:

Expression_2

sum(costs)

Condition: sum(sales)>0

Oderwise it will crash.

Thank you