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

      ProductDayMetric_1ObjectiveThreshold
      110.560.5Y
      210.320.5N
      120.290.5N
      220.60.5Y

       

      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!