Working with dates

[Anonymous]

Hi I have this table with date field in format M/D/YYYY and I want to show it like MMM-YY in QlikView, I want to create it from the script so I'm simply doing this date(SUBMIT_DT,'MMM-YY') which gets me the right format, the problem is, it doesn't group together in charts / list box... look at the picture, how can I solve it without converting it to text (so I can sort it correctly)

[maxgro]

see attachment

[Anonymous · Accepted solution]

Hi oscar,

What do you mean by grouping?

is data duplicated?

Regards

Neetha

[MK_QSL]

Add below in your script

Date(MonthStart(Date#(SUBMIT_DT,'M/D/YYYY')),'MMM-YY') as Submitted

or

use below in your chart as a Calculated Dimension or you simply use to create a field in list box

Date(MonthStart(Date#(SUBMIT_DT,'M/D/YYYY')),'MMM-YY')

[Anonymous]

SIngle values in chart axis and list box, normally you can have multiple records with same value, but here they will appear just once

[jpapador]

Use this on the date in the script:

Date(MonthStart(SUBMIT_DT), 'MMM-YY') as MonthYear,

[Anonymous]

Thanks, works like a charm

[Anonymous]

THanks you! I'd wish I could mark two answers as correct, I appreciate your help!

[MarcoWedel]

LOAD Date(MonthName(SUBMIT_DT),'MMM-YY') as Submitted

Resident yoursource;