2 Replies Latest reply: Jun 14, 2012 6:25 AM by Hatus Peters RSS

    How does Conditional option in expression tab works?

    Hatus Peters

      Hi

       

      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

      BR

        • How does Conditional option in expression tab works?
          Stefan Wühl

          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 Peters

              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