6 Replies Latest reply: Jun 5, 2017 8:05 AM by Alejandro Martínez Otal RSS

    If () condition not working as intended

    Alejandro Martínez Otal

      Hello guys!


      I created the following table



      What I want to do, is that if the value Metric_1 is higher than 0.5, put the value 'Y' in Threshold, otherwise, put 'N'.

      I used the following formula in Threshold with no luck.


      if([Metric_1] < 0.5,'Y','N')


      it should be quite simple, isn't it?

      I didn't add the formula for metric_1 here because I don't think its important, but I might be missing something crucial in Qlik as the condition seems pretty simple.


      Kind regards!