topic Re: How to show dates format in QlikView

How to show dates format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to show dates format

prieper — Fri, 05 May 2017 12:52:11 GMT

LOAD DISTINCT ??

Re: How to show dates format

tresB — Fri, 05 May 2017 12:54:02 GMT

Where are you getting the data from? Excel?

Re: How to show dates format

Anonymous — Fri, 05 May 2017 12:55:18 GMT

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

Re: How to show dates format

tresB — Fri, 05 May 2017 12:59:03 GMT

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

MonthName(Date) as Month

Re: How to show dates format

tresB — Fri, 05 May 2017 13:05:36 GMT

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

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

Re: How to show dates format

el_aprendiz111 — Fri, 05 May 2017 13:17:40 GMT

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
];