topic Re: Date in QlikView

Date

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

HI i have a field called date and the format is like

01/01/2016 and so on I want to convert this date like

jan-2016 and so on...

Can someone please help me on this

antoniotiman — Sat, 29 Jul 2017 04:43:53 GMT

Hi John,

assuming 01/01/2016 is DD/MM/YYYY

set Your Format Date variable in script

SET DateFormat='DD/MM/YYYY'; //(or MM/DD/YYYY)

MonthName('01/01/2016') -> jan 2016

or Date('01/01/2016','MMM-YYYY') -> jan-2016

General conversion is

Date(Date#('01/01/2016','DD/MM/YYYY'),'MMM-YYYY') -> jan-2016

Replace 01/01/2016 with Your DateField

Regards,

Antonio

smilingjohn — Sat, 29 Jul 2017 05:13:41 GMT

Thanks Antonio,

PLease find my attachment i have taken your suggestion and implemented and it converted what i was needed ,

IN the QVW and Excel i have attehc ...I want to generate one more date field here how do i do it in qlikview ????

can you please help me for this

Thanks

antoniotiman — Sat, 29 Jul 2017 06:01:09 GMT

Which new date field ?

Can You clarify ?

vinieme12 — Sat, 29 Jul 2017 09:27:52 GMT

You can re-use the same fields to generate as many fields, example

LOAD Customers,

Created as Created_TimeStamp,

MonthName(Created ) as Created,

WeekYear(Created) as CreatedWeek,

//Updated,

Updated as Update_TimeStamp,

MonthName(Updated ) as Updated,

// Resolved,

Resolved as Resolved_TimeStamp,

MonthName(Resolved ) as Resolved,

// Closed,

Closed as Closed_TimeStamp,

MonthName(Closed ) as Closed

FROM

(ooxml, embedded labels, table is Sheet1);