Skip to main content
Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
antoniotiman
Master III
Master III

Another way

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