5 Replies Latest reply: Oct 25, 2017 10:58 PM by Shamit Shah RSS

    Date expression

    Shamit Shah

      Hi,

       

      I have the following variables and want to get the total number of shifts for today:

       

      vToday=Date(today())

       

      vShiftstoday = Count({<Date={"=$(vToday),'DD/MM/YYYY')"}}>}[Shifts.Approved])

       

       

       

      I then created a text object in Qlik Sense and entered =vShiftstoday in the expression box but it is showing text

       

      = Count({<Date={"=$(vToday),'DD/MM/YYYY')"}}>}[Shifts.Approved])

       

      instead of a number.

       

      Any idea where it has gone wrong?

       

      Thanks