Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

UPDATE DATE as update field display in Qlik Sense as 42515 ?

Hi All

Below is the load script , that read from Excel file .

LOAD

 

  CUST_ID  as [CUST_ID],

    [UPDATE DATE] AS [update],

    STATUS       as [status],

  PAYMENT_DATE as [PAYMENT_DATE]

FROM [$(vINPUTPath)$(vFile18)] (ooxml,embedded labels, table is [TID]);

I use Binary load to read the above QVW file. When in Qlik View i can create table report to display both date no issue.

But when i use Qlik Sense to read the above 2 date , i am not able to read the date , it turn the date into number 42515.

Hope some one can advise me what are the changes i need make , in order for Qlik Sense able to display date as 23/6/2016 ?

Paul

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

try like this

LOAD

  CUST_ID  as [CUST_ID],

   date( [UPDATE DATE]) AS [update],

    STATUS       as [status],

  date(PAYMENT_DATE) as [PAYMENT_DATE]

7 Replies
arulsettu
Honored Contributor III

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

try like this

LOAD

  CUST_ID  as [CUST_ID],

   date( [UPDATE DATE]) AS [update],

    STATUS       as [status],

  date(PAYMENT_DATE) as [PAYMENT_DATE]

paulyeo11
Valued Contributor II

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

My QS QVF

Take note that the field name = UPDATE , is display as number not date format.

I also notice in QS Table , i am not able set the field as date . it does not allow us to set.

PAul

arulsettu
Honored Contributor III

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

Untitled.png

sureshqv
Esteemed Contributor III

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

update.PNGhi,

PFA

paulyeo11
Valued Contributor II

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

Hi Arul

Thank you very much , it work

Paul

paulyeo11
Valued Contributor II

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

Hi Chanty

Arul approach work fine .

When i open your attach file , i still see number and not see the date.

After i try Arul by add Date( it work fine.

Paul

arulsettu
Honored Contributor III

Re: UPDATE DATE as update field display in Qlik Sense as 42515 ?

welcome

Community Browser