Date Slider : working with Filtered Dates

simonb2013 — Tue, 29 Apr 2014 12:49:23 GMT

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.

topic Date Slider : working with Filtered Dates in QlikView

Date Slider : working with Filtered Dates