Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try like this
LOAD
CUST_ID as [CUST_ID],
date( [UPDATE DATE]) AS [update],
STATUS as [status],
date(PAYMENT_DATE) as [PAYMENT_DATE]
try like this
LOAD
CUST_ID as [CUST_ID],
date( [UPDATE DATE]) AS [update],
STATUS as [status],
date(PAYMENT_DATE) as [PAYMENT_DATE]
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
hi,
PFA
Hi Arul
Thank you very much , it work
Paul
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
welcome