topic Re: Distinct dates in QlikView

Distinct dates

Fri, 24 Aug 2012 19:33:09 GMT

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.

Re: Distinct dates

Fri, 24 Aug 2012 20:12:14 GMT

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

Re: Distinct dates

Fri, 24 Aug 2012 20:23:32 GMT

Fantastic, and thank you very much

Re: Distinct dates

Thu, 30 Aug 2012 14:54:17 GMT

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.

Re: Distinct dates

Thu, 30 Aug 2012 15:52:50 GMT

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:

Re: Distinct dates

Thu, 30 Aug 2012 18:52:42 GMT

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 ..?

Re: Distinct dates

whiteline — Thu, 30 Aug 2012 19:09:03 GMT

Just use the list box.