Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikSense Data Manager

I am trying to load two attached files in QlikSense using Data Manager. I am getting below script.

[Sales2010]:

LOAD

  Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [InvoiceDate],

  [Sales] AS [Sales],

  [Customer] AS [Customer];

LOAD [InvoiceDate],

  [Sales],

  [Customer]

FROM [lib://Downloads/Sales2010.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[Sales2011]:

LOAD [InvoiceDate],

  [Sales],

  [Customer]

FROM [lib://Downloads/Sales2011.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

RENAME TABLE [Sales2010] TO [Sales2010-Sales2011];

I don't understand why InvoiceDate from Sales2010 is converted and InvoiceDate from Sales2011 is not getting converted to appropriate date fromat.

The date format in script is

SET DateFormat='DD/MM/YYYY';

Is this a bug ?

Regards,

MK

1 Solution

Accepted Solutions

Re: QlikSense Data Manager

The Data Manager is simply not very clever yet. It's improving with each release, but still has a long way to go. In this case the magic date conversion is only applied to the first load statement. It's a bug. Hopefully it will be fixed in new release.


talk is cheap, supply exceeds demand
9 Replies
rittermd
Honored Contributor

Re: QlikSense Data Manager

It seems that whichever one you load 2nd has the issue with the date not being formatted.  I unfortunately am not sure what is going on with this.

Re: QlikSense Data Manager

Both files are having same data. I have only changed 2010 to 2011.

There should not be any issue with formatting..

arulsettu
Honored Contributor III

Re: QlikSense Data Manager

when i tried with above files i got this

[Sales2010]:

LOAD

  Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [InvoiceDate],

  [Sales] AS [Sales],

  [Customer] AS [Customer];

LOAD [InvoiceDate],

  [Sales],

  [Customer]

FROM [lib://Downloads/Sales2010.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[Sales2011]:

LOAD

  Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [Sales2011.InvoiceDate],

  [Sales] AS [Sales2011.Sales],

  [Customer] AS [Sales2011.Customer];

LOAD [InvoiceDate],

  [Sales],

  [Customer]

FROM [lib://Downloads/Sales2011.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

miguelbraga
Valued Contributor III

Re: QlikSense Data Manager

Hi Manish Kachhia,

Mate the problem here is simple. The solution is here:

[Sales2010]: 

LOAD 

  Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [InvoiceDate], 

  [Sales] AS [Sales], 

  [Customer] AS [Customer]; 

LOAD [InvoiceDate], 

  [Sales], 

  [Customer] 

FROM [lib://Downloads/Sales2010.csv] 

(txt, codepage is 1252, embedded labels, delimiter is ',', msq); 

 

 

[Sales2011]: 

LOAD Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [InvoiceDate], 

  [Sales], 

  [Customer] 

FROM [lib://Downloads/Sales2011.csv] 

(txt, codepage is 1252, embedded labels, delimiter is ',', msq); 

RENAME TABLE [Sales2010] TO [Sales2010-Sales2011];

Hope this help you mate

Regards,

MB

Highlighted

Re: QlikSense Data Manager

Have u tried using data manager?

Re: QlikSense Data Manager

I am not looking for solution on how to make date in proper format. I want to understand why Data Manager is not self converting both dates.

Re: QlikSense Data Manager

The Data Manager is simply not very clever yet. It's improving with each release, but still has a long way to go. In this case the magic date conversion is only applied to the first load statement. It's a bug. Hopefully it will be fixed in new release.


talk is cheap, supply exceeds demand
dcj
Valued Contributor II

Re: QlikSense Data Manager

Dear Manish,

   I always format the value on load script to ensure correct format as I need, ignoring the date format.

   I believe a great test should be simulate on old version and Qlikview also.

   Have you tried to open a case? I guess date format the should be respected, but ....

Have a great day.

arulsettu
Honored Contributor III

Re: QlikSense Data Manager

yes bro