Distinct dates

[#1]

Hope some one can assist with an example with the attached spreadsheet.

I have a set of data containing a running list of values that will replicate each month..

Each data set has a number of fields and dates associated against each set.

I am looking to create a listview with the distinct dates based upon the full set of data, so that when I select a date from the list view, records within that date range selection are shown.

[#2 · Accepted solution]

This is most easily done through the use of a master calendar in the script.  See attached.

[#3]

Fantastic, and thank you very much

[#4]

Another Question for you .. the script works great, but actually generates all dates between start date and next load date .. so If I load twice over a 2 month period I may end up with 58 dates with no associated data ..

Is there a way to just show the actual load dates .. and not everthing in between?

Thanks in advance.

[#5]

Is your actual load date the same as 'DateCreated'? If so, you can just create a list box with the field 'DateCreated' and it will only show the records with data associated with it. The only limitation here is that it makes it a bit more difficult to select ranges (ex. the days may go 8/22,8/24,9/2), which can also make your graphs look skewed if you use that field as an axis.

My recommendation is to just adjust the min and max dates in the script. For example, you can make the min date a set date or you can adjust the min date to equal a different field (ex. LoadDate). That is adjusted here:

[#6]

So I have set the text box to [TS Date Created], it has to be this as the QVApp is a template that allows the population of it based on any underlying repository I use for analysis.

The load script is changed to

Problem being the list box .. pointing to [TS Date Created] shows ... (where the highlights are the actual only dates)

I want the calendar .. but I only want the actual dates available in the dropdown ..?

[whiteline]

Just use the list box.