topic Re: Duplicate dates in date field in QlikView

Duplicate dates in date field

Fri, 01 May 2015 12:55:03 GMT

How can I avoid displaying duplicate dates in a date field? This field has been constructed from multiple different tables and the same date is displaying more than once both in a list box and a chart I have. Field is normalized to just show the date so time isn't causing the issue. Appreciate the help.

Re: Duplicate dates in date field

Gysbert_Wassenaar — Fri, 01 May 2015 15:49:12 GMT

You probably have timestamps among your dates. 01/01/2015 00:00:00 and 01/01/2015 07:32 have the same date, but not same value. You can cut off the time part by using the floor function: date(floor(MyDate),'MM/DD/YYYY') as MyDate

Re: Duplicate dates in date field

Fri, 08 May 2015 11:28:20 GMT

I think my syntax is in correct for this

date(floor(WeekEnd(date#(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'),'MM/DD/YYYY')), 0, 2),'MM/DD/YYYY') as

'ActionDate'

Do you know what i'm doing wrong here?

Re: Duplicate dates in date field

Gysbert_Wassenaar — Fri, 08 May 2015 11:41:57 GMT

Well, for one thing you can't use 0 as base for the floor function. Perhaps you meant 0 and 2 as parameters for the weekend function:

date(floor(WeekEnd(date#(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'),'MM/DD/YYYY'), 0, 2)),'MM/DD/YYYY') as 'ActionDate'

Other than that, no idea. I have no idea in how many tables the ActionDate field exists.