Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod22kv
Creator
Creator

Help in date

Hi,

I have date as Bellow. if i use text object with date(43466,'DD/MM/YY')  Its working fine. if i use it in list object (date(Date,'DD/MM/YY')) its not working may i know why?

Date
43466
43467
43468
43469
43470
43471
43472
43473
43474
43475
43476
43477
43478
43479
43480

 

Thanks and Regards,

Vinod

1 Solution

Accepted Solutions
rubenmarin

You don't need crossstable with this excel and dates loads ok.

In date test.qvw all dates are loaded as text, not dates or numbers, you can load from resident to create the dates adding:
LOAD *,
Date(Num#(Date)) as Date InDateFormat
resident [TableName];

DROP [TableName];

View solution in original post

5 Replies
poonam_kulwal
Partner
Partner

Hi Vinod,

You cannot use Date field as it is in list box.
Crete a list box with expression "=date(Date,'DD/MM/YY')".

It should work.

 

Regards,

Poonam

rubenmarin

Hi, it's working for me (sample attached), can you post a sample where it doesn't works?

vinod22kv
Creator
Creator
Author

Hi i am trying to do cross table with date

vinod22kv
Creator
Creator
Author

Please find the data

rubenmarin

You don't need crossstable with this excel and dates loads ok.

In date test.qvw all dates are loaded as text, not dates or numbers, you can load from resident to create the dates adding:
LOAD *,
Date(Num#(Date)) as Date InDateFormat
resident [TableName];

DROP [TableName];

View solution in original post