1 Reply Latest reply: Dec 14, 2015 11:00 AM by Sunny Talwar RSS

    Conditional Expression

      Hi,

       

      For the below mentioned expression, I would like to only see the values that are above 0.1 to be displayed on the chart and those below this are to be suppressed, Please can someone help me out on this:

       

      if(avg($(v_expr1) [EAC Total GP(%)])>avg($(v_expr1) [ASBL Total GP(%)]),
      (avg(
      $(v_expr1) [EAC Total GP(%)])-avg($(v_expr2) [EAC Total GP(%)]))}


      QlikView Expressor

        • Re: Conditional Expression
          Sunny Talwar

          May be this:

           

          If(

               If(Avg($(v_expr1) [EAC Total GP(%)]) > Avg($(v_expr1) [ASBL Total GP(%)]),
               (Avg($(v_expr1) [EAC Total GP(%)]) - Avg($(v_expr2) [EAC Total GP(%)]))) > 0.1,

               If(Avg($(v_expr1) [EAC Total GP(%)]) > Avg($(v_expr1) [ASBL Total GP(%)]),
               (Avg($(v_expr1) [EAC Total GP(%)]) - Avg($(v_expr2) [EAC Total GP(%)]
          )))

          )