3 Replies Latest reply: Sep 9, 2010 10:01 AM by Tresesco B RSS

    how do you get dates to appear in date format rather than number using class function

      I have successfully used the class function to give me the number or orders within date brackets but the problem i have is that the dates are showing up in the number format so my table looks like this:

      40268<number or orders< 40270

      40270<number of orders<40272

      This isn't very easy for the end user to see the dates how do i get QLikView to show the dates in DD.MM.YY format?

      The calculated dimension i have used is below

       

      =class(DateCompleted,vWidth,'Number of Orders')



      Thanks