14 Replies Latest reply: Nov 12, 2015 6:58 AM by daniesh shaikh RSS

    Use Greater and less than function in Qlikview

    daniesh shaikh

      Hi All,

       

      I am trying to create a chart for employees come to time and go on time.

      One of the tables have columns name , IN_TIME ,OUT_TIME, DELAY

       

      I want to write a expression for employees who are coming between 8 AM to 9 AM  and going between 3 PM to 4 PM, They are coming on Time.

      For IN_TIME >=8 and <=9 Comes early

      OUT_TIME >=3 PM and 4 PM Going on time.

       

      Please help me writing the expression and also assist me that which graph should i use for this.

       

      Thanks