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

    creation of an indicator with conditions



      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 !