Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
oscarmqz
Creator III
Creator III

Working with dates

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)

fechas.JPG

1 Solution

Accepted Solutions
neetha_p
Master
Master

Hi oscar,

What do you mean by grouping?

is data duplicated?

Regards

Neetha

View solution in original post

8 Replies
maxgro
MVP
MVP

see attachment

neetha_p
Master
Master

Hi oscar,

What do you mean by grouping?

is data duplicated?

Regards

Neetha

View solution in original post

MK_QSL
MVP
MVP

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')

oscarmqz
Creator III
Creator III

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
Partner
Partner

Use this on the date in the script:

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

oscarmqz
Creator III
Creator III

Thanks, works like a charm

oscarmqz
Creator III
Creator III

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;