Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Setting a date Format

I have some data in a field called Month.  It has the format of    'MMM YY   Example:

'Apr 17

'Feb 17

'Jan 17

I would like to use these as month reporting

the ' is part of the actual data

can someone help

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Another way

MonthName(Date#(DateField,Chr(39)&'MMM YY'))

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Not sure what you are looking?

Kindly explain with example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anil_Babu_Samineni

May be one possible solution is this?

LOAD FieldName, Month(Date#(Replace(FieldName, Chr(39), ''),'MMM YY')) as FieldName2;

LOAD * Inline [

FieldName

'Apr 17

'Feb 17

'Jan 17

];

Create Tabular table with FieldName2 as dimension and metric for expression

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
antoniotiman
Master III
Master III

Another way

MonthName(Date#(DateField,Chr(39)&'MMM YY'))