Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vinod22kv
Contributor

Help in date

Hi,

I am trying to extract the date from hte below field, All the records has the same date but when i am using the date function ilst box DUPLICATE has to remove and has to menction only single date since all has same date and diffternt time, but i am getting all the fileds with same data.

 

Contact Date and Time
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50

Expected out put in list box.

24/05/2018

But getting out put in list box.

 

24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018
24/05/2018

Regards,

Vinod.

1 Solution

Accepted Solutions

Re: Help in date

try date(floor(dateField))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

4 Replies

Re: Help in date

try date(floor(dateField))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

parthesh
Contributor

Re: Help in date

Hello can you provide scenario in qvw? because i am not able to reproduce the scenario in my test qvw.

Partner
Partner

Re: Help in date

Hi,


Try this

Date(Floor(Subfield([Contact Date and Time], ' ' , 1)),'DD/MM/YYYY')

qlikviewwizard
Honored Contributor II

Re: Help in date

Hi,

Please check this.

Data:

LOAD date(Date#(DATE,'DD/MM/YYYY hh:ss'),'DD/MM/YYYY') as DATE inline [

DATE

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50

24/05/2018 04:50];