topic Duplicate date entries on List Box in QlikView

Duplicate date entries on List Box

Tue, 11 Feb 2014 20:18:50 GMT

Hi all,

I have a strange behavior with one of my tables its shows duplicate entries as on the bellow image.

I should have an entry for each date.

Any help will be much appreciated.

Tue, 11 Feb 2014 20:20:20 GMT

hey Andrei,

Its because of the timestamp attached with the date. User Floor(Field). This will remove the time portion attached to the date.

Thanks

Tue, 11 Feb 2014 20:26:45 GMT

Hi Ajay,

Many thanks. That worked perfectly.

Andrei