3 Replies Latest reply: Jun 14, 2016 4:30 PM by Vincent Nguyen RSS

    BELOW is not a valid function

    Vincent Nguyen

      Hi, I need helping getting the Below function to work. Here is what I have and the issue:

       

      LOAD ID,

           Size,

           Weight,

           if(ID = Below(ID), 0, Weight) as [Corrected Weight];

       

      The intention is to compare the current ID with the line below and if the IDs match, then ignore the weight of all but the last weights (all of the ignored weights are the same value). I've read and tried to apply what's written in Below - chart function ‒ Qlik Sense, but always get the error in the title.