Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

3 Replies
tresesco
MVP
MVP

Hi,

Use ............. Date( DateValueField, 'DD-MM-YY' ) as Date...

Regards,

tresesco

Not applicable
Author

Do i put this in the calculated dimension?

My dimension now looks like this:

=class(Date(DateCompleted,'DD-MM-YY'),vWidth,'Purchase Size')

which doesn't work. In the load scipt the date pulls through in DD-MM-YY format but the class function automatically puts it in number format but i can't see how to change this.

Is there another function other than class that i could use?



tresesco
MVP
MVP

Hi,

If you have got the desired date range in a field (say-NumericDate) after applying Class function, then what you can do is, get the resident of that field(NumericDate) and apply the date function as i told earlier, i.e. Date(NumericDate,'DD-MM-YY') as FinalDate ..............in the SCRIPT.

Regards,

tresesco