Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wilfredsj
New 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

Re: Date conversion

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;

Re: Date conversion

Or this

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

Employee
Employee

Re: Date conversion

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;

wilfredsj
New Contributor II

Re: Date conversion

‌Clever Anjos,

it’s works perfect, super!

thanks a lot.

WIlfred

wilfredsj
New Contributor II

Re: Date conversion

‌it works great!

thanks for the efforts

WIlfred

Community Browser