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

    Date expression

    Shamit Shah



      I have the following variables and want to get the total number of shifts for 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?