So,
I have a table with an entry for every day of the year.
2013-01-01, 2013-01-02, 2013-01-03 ... 2013-12-31.
I also have a second column in that table called dayOfMonth, and this contains only the day part of the date.
[myDate] [dayOfMonth]
2013-02-14 14
2013-02-15 15
My entire QV app is filtered by 'dayOfMonth' .... in other words, users may view data for every nth of each month.
This is a required filter, so it will always be 'on' and always for 1 value only (no multi select).
This works fine for the app as a whole.
However, it causes me problems with the date slider.
By default, I set the date slider to use [myDate], and yes I now have the slider showing the 2nd, 3rd, 4th of months, even though my app is filtered to [dayOfMonth]=1.
It will not actually function as a slider unless I click 'exactly' on a 1st value, which can be tricky and far from intuitive.
How may I get my slider to use only the [myData] values that have [dayOfMonth] = @userFilter ?
Many Thanks.
