topic Re: Getting Month Name from Date (dd/mm/yyyy) in QlikView

Getting Month Name from Date (dd/mm/yyyy)

jlampard40 — Fri, 15 Nov 2024 23:16:13 GMT

Hi Guys - I need to show the variations in months across 5 years worth of data. So, just want to highlight which months of the year generally show the highest demand for our services. I have two dates I need to use - Request Date, and Event Date.

How can I get Qlikview to allow me to extract the month name, so I can use this in the dashboard I've developed? The script (relevant fields extracted) is as follows:

Directory;
LOAD

AD_Request_Date as Request_Date

AD_Event_DT as Event_Date

FROM
[..\xxxxx\xxxx\xxxx\xxxx_*.csv]

many thanks guys!

Re: Getting Month Name from Date (dd/mm/yyyy)

Anil_Babu_Samineni — Fri, 22 Jan 2021 12:59:48 GMT

Perhaps this

LOAD

AD_Request_Date as Request_Date,

MonthName(AD_Request_Date) as MonthName

FROM
[..\xxxxx\xxxx\xxxx\xxxx_*.csv]

Concatenate

Directory;
LOAD

AD_Event_DT as Event_Date,

MonthName(AD_Event_DT) as MonthName

FROM
[..\xxxxx\xxxx\xxxx\xxxx_*.csv]

Re: Getting Month Name from Date (dd/mm/yyyy)

jlampard40 — Fri, 22 Jan 2021 13:59:38 GMT

Thanks @Anil_Babu_Samineni - unfortunately it is pulling all of the dates in format MMM-YY. I just want Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec. So I can compare seasonal / monthly trends.

Any ideas?

Re: Getting Month Name from Date (dd/mm/yyyy)

Anil_Babu_Samineni — Fri, 22 Jan 2021 14:21:39 GMT

You can try

Month(AD_Request_Date) as MonthName

Re: Getting Month Name from Date (dd/mm/yyyy)

jlampard40 — Fri, 22 Jan 2021 15:16:34 GMT

Thank you @Anil_Babu_Samineni