5 Replies Latest reply: Jan 30, 2017 10:00 PM by PRIYANTHA BANDARA RSS

    Expression Help

    PRIYANTHA BANDARA

      Dear Experts,

       

      I used following expression in my application for a date calculation.

       

      (IF(STATUS='ACTIVE', NUM(TODAY())-(DATE(DATE#(LON_DATE))),DATE(DATE#(SET_DATE))-DATE(DATE#(LON_DATE)))+1)

       

      This expression counts the number of days from the 'LON_DATE' to the current date including 'LON_DATE'.

       

      So now i need to remove(Exclude) the all "Saturdays and Sundays" comes after 'LON_DATE' from this calculation.

       

      How i can do this with Qlick view.

       

      Rgds,

      Priyantha.