Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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