Date List Box

evansabres — Wed, 15 Feb 2017 20:30:17 GMT

I have a date field called 'StartDate' which is displays in the data as

2/8/2017 12:00

I want to create a list that displays the dates (StartDate) however, within the data it is possible for the same actual date to appear twice. For example

StartDate

2/8/2017 15:15

2/8/2017 12:00

2/8/2017 17:47

In my script, I have transformed the date to only pull in the left 10 characters of the field by doing

LEFT(StartDate, 10) as cmpSTRTDTE so that when I create a list box, the data appears as 2/8/2017. However, there are still multiple values for 2/8/2017.

Is there a way to either in the script or in a calculated dimension only display the date once?

Ideally, I want the list to display the StartDates but only have each date appear once.

Re: Date List Box

sunny_talwar — Wed, 15 Feb 2017 20:34:14 GMT

Transform using Floor function

Date(Floor(StartDate)) as StartDate

Re: Date List Box

evansabres — Wed, 15 Feb 2017 20:37:51 GMT

Great thank you

topic Date List Box in QlikView

Date List Box

Re: Date List Box

Re: Date List Box