3 Replies Latest reply: Mar 23, 2016 11:22 AM by Sunny Talwar RSS

    problems with date variable in set analysis

    Neil Deeley

      Hi there,

      I've created a variable in using the variables interface to display todays date minus 30 days, called vToday:

       

      Image1.png

       

      When I output this variable to a text box there's no problem displaying the date (tho I need to format it to see the date rather than the numerical value of the date:

       

      image2.png

       

      However, when I try to use this variable in set analysis, QlikSense displays no results. A hard coded date does:

       

      image3.png

       

      The syntax I am using is:

       

      count({$<Date={'>=22/02/2016'}>} AlarmCount)

       

      count({$<Date={'>=$(vTodaysDate)'}>} AlarmCount)


      In the data load editor my date format is set to SET DateFormat='DD/MM/YYYY'


      It must be the formatting of the date in the variable, but I have tried date(Today()-30, 'DD/MM/YYYY') and there is no difference.


      It's driving me mad...any help greatfully received.


      Cheers

      Neil