Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Date conversion

Dear All,

As starter cannot get de date conversion into the tabel:

VastOpFunctie:

Crosstable (Maand, OpFunctie)

LOAD  PersoonsID,

    "42909",

    "42939",

    "42970",

    "43001",

    "43031",

    "43062",  

FROM [lib://qlikid_wilfredsj/test.xlsx]

(ooxml, embedded labels, table is Blad1)

Want I want is convert  "42909" to month, Year

I figure out i should be Date(Maand,'MMM YYYY') as Maand but where to place it in the script?

So that the "maand" column holds  march 2017 in stead of 42909"  ...

I would really appreciate is someone can provide me the right script.

5 Replies
Highlighted

Try this

VastOpFunctie:

Crosstable (Maand, OpFunctie)

LOAD  PersoonsID,

    "42909",

    "42939",

    "42970",

    "43001",

    "43031",

    "43062", 

FROM [lib://qlikid_wilfredsj/test.xlsx]

(ooxml, embedded labels, table is Blad1)

FinalTable:

NoConcatenate

LOAD PersoonsID,

     Date(Num#(Maand), 'MMM YYYY') as Maand,

     OpFunctie

Resident VastOpFunctie;


DROP Table VastOpFunctie;

Highlighted

Or this

Date(MonthStart(Num#(Maand)), 'MMM YYYY') as Maand,

Highlighted
Employee
Employee

Try this

VastOpFunctie:

Crosstable (Maand, OpFunctie)

LOAD  PersoonsID,

    "42909",

    "42939",

    "42970",

    "43001",

    "43031",

    "43062", 

FROM [lib://qlikid_wilfredsj/test.xlsx]

(ooxml, embedded labels, table is Blad1);

Noconcatenate

load

PersoonsID,

Date(Trim(Maand),'MMM/YYYY') AS Maand,

OpFunctie

Resident VastOpFunctie;

drop table VastOpFunctie;

Highlighted
Contributor II
Contributor II

‌Clever Anjos,

it’s works perfect, super!

thanks a lot.

WIlfred

Highlighted
Contributor II
Contributor II

‌it works great!

thanks for the efforts

WIlfred