Re: How to show dates format - Qlik Community

Anonymous · ‎2017-05-05

Hi All,

Below is my format

Jan - 17

Feb - 17

Mar - 17

Apr - 17

May - 17

out put be like

Jan -17

Feb -17

Mar -17

Apr -17

May -17

Regards,

prieper · ‎2017-05-05

LOAD DISTINCT ??

tresesco · ‎2017-05-05

Where are you getting the data from? Excel?

Anonymous · ‎2017-05-05

Nope!!

Actuval data is like this:

1/10/2017

1/11/2017

1/12/2017

1/17/2017

1/18/2017

1/25/2017

1/27/2017

2/6/2017

2/8/2017

2/14/2017

2/28/2017

3/8/2017

3/22/2017

3/23/2017

4/7/2017

4/10/2017

4/25/2017

5/1/2017

tresesco · ‎2017-05-05

You are probably using date() to format it to see the MMM-YYYY format. Instead try using monthname(), like:

MonthName(Date) as Month

tresesco · ‎2017-05-05

And if you need that '-' too, try like:

Date(MonthStart(Date), 'MMM-YYYY') as Month

el_aprendiz111 · ‎2017-05-05

hI,

LOAD Distinct Date;
LOAD * Inline
[
Date
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Feb - 17
Feb - 17
Feb - 17
Feb - 17
Feb - 17
Mar - 17
Mar - 17
Mar - 17
Mar - 17
Apr - 17
Apr - 17
Apr - 17
May - 17
];