Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
simonb2013
Creator
Creator

Date Slider : working with Filtered Dates

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.

0 Replies