Date format convert issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I created one table as below's screenshot, you can see that, from column H to M, is date format.

The problem is when I load into QlikView by script, the date column will display in number.

So I modified the script:

Directory;

CrossTable(Month, Data, 7)

LOAD Dept,

Section,

[Job No],

[Job Type],

[Job Name],

[Customer 1],

[Customer 2],

[42826],

[42856],

[42887],

[42917],

[42948],

[42979]

FROM

[17A JOB List.xlsx]

(ooxml, embedded labels, table is job);

Test:

Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Directory;

DROP Table Directory;

However, when I reload, QlikView always pop-up error message:

Table not found

Test:

Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Directory

So I confused, I don't know how to revise the script. I have uploaded the QVW file in attachment. Does somebody can help me.

Thx a lot!

Re: Date format convert issue

md_qlikview — Wed, 26 Jul 2017 03:26:21 GMT

Hi,

Try by giving Proper name to your first loaded table instead of Directory,

Say

Table1:

Final:

Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Table1

Drop Table Table1;

Re: Date format convert issue

Wed, 26 Jul 2017 03:36:28 GMT

Hi Milind

You're right, seems need to change to another name, and it is working now.

Thx

topic Re: Date format convert issue in QlikView

Date format convert issue

Re: Date format convert issue

Re: Date format convert issue