5 Replies Latest reply: Mar 19, 2018 9:08 PM by Paul Cu RSS

    variables in an expression

    Paul Cu

      Can someone help me?

       

      Im still new using qlik sense. I have a problem using variables / functions inside an expression. Whats wrong with this.

       

      I have a variable  vHour

      HOUR(TIMESTAMP(NOW()))

       

      running this return 0 value (current time im running this is at 12:50)

      =Count({<DepartureTimeScheduleAddedHour={"<=$(=vHour)"}>}DepartureTimeScheduleAddedHour)

       

      running this returns a value of 18

      =Count({<DepartureTimeScheduleAddedHour={"12"}>}DepartureTimeScheduleAddedHour)

       

      Can you guide me as to what im doing wrong

       

      Thanks