topic Re: Help in date in QlikView

Help in date

vinod22kv — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Help in date

poonam_kulwal — Tue, 21 May 2019 08:22:55 GMT

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

Re: Help in date

rubenmarin — Tue, 21 May 2019 08:23:23 GMT

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

Re: Help in date

vinod22kv — Tue, 21 May 2019 12:35:57 GMT

Hi i am trying to do cross table with date

Re: Help in date

vinod22kv — Tue, 21 May 2019 12:37:01 GMT

Please find the data

Re: Help in date

rubenmarin — Tue, 21 May 2019 13:52:48 GMT

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];