10 Replies Latest reply: Mar 9, 2016 5:38 AM by margaux devay RSS

    creation of an indicator with conditions

    margaux devay

      Hello,

       

      I am trying to create an indicator in Qlik

       

      if my "dif date" is Superior to 90 days , i want to sum those value and divided by the total .

       

      If the result is Superior to 4% led red if inferior led green

       

      my unworking formula :

       

      = if((Diff_Date > 90 , sum(([Value]) / ( Value)) < 0.04),'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

      Thank you  for your help !