hello, I'm more than 1 hour researching a timetable to do the following: I have two on my dashboard calendar object, where one is to select the start date and end date to another. to make two objects using search, where at first I was selecting a particular date field or higher and another that would select the same date in another table with only smaller or equal. Is to do with the calendar object or something that looks like the calendar (I saw some very good examples of John Witherspoon)?
You could do something with the calenders during the LOAD ... like adding the possible dates (start / end) in some linktable.
I did had a simular problem and John Witherspoon gave some good examples for this.
Something else we once used because the LOAD solution was no option there ... use 2 calendars which are not connected to any tables and use the Set Analysis to get the right selection.
This is not really the best thing for the performance ... so I would go with the first solution ... do some pre-loading for the calendar in the LOAD script.
In dimensions this doesn't work ... dimensions with expresions can't handle everything 😉
What you should do is use the set analysis on the expression columns.
When all expression columns contain a null value the total row is not shown (so the dimension is not shown too) ...
This could be done by using e.g. an if expression which only shows the data when having the start and ending date between the selection ... or using a set analysis expression.
If you have 2 calander fields to choose from ... and you make a selection ...
you should do something like this in the expression:
if( date_from_table >= selectedvalue(start_date) and date_from_table <= selectedvalue(end_date), value_to_show)
the function for selectedvalue is not correctly ... but i just closed the server I work on ... it should be the function to select the value selected for a field ...
Hope this helps ... if not, try posting a sample qlikview so we can help you there.
