topic Change Slider Values based on selections in QlikView

Change Slider Values based on selections

Fri, 04 Feb 2011 10:47:35 GMT

I tried to insert a Slider for a date field. This date field contains values from 01.01.2010 till 31.01.2011. I build new fields: day/week/month and year (based on that date field). All fields (date, day, week, month, year) are linked to each other. The user can choose for example "Mai 2010". Now i would expect the slider to change to 01.05.2010 til 31.05.2010. But that does not happen. It seems that i need a formula for calculating, which dates are in the choosen range.

I tried to work with variable to use the min and max values. That is not working, because it is showing only numbers instead of dates. Converting these number to a date is not working, too.

There is another thread about the same problem, but that did not helped me a well:
http://community.qlik.com/forums/t/33859.aspx

Regards, Martin

Change Slider Values based on selections

Anonymous — Fri, 04 Feb 2011 11:26:29 GMT

Min and Max Values of the selected date should work.

It all depends on you data format I think.

Can you share your document so we can take a look?

Change Slider Values based on selections

Fri, 04 Feb 2011 15:42:12 GMT

Here is an example of it...
Thanks a lot!

Martin

Change Slider Values based on selections

Fri, 04 Feb 2011 17:07:21 GMT

Hi dj-kalle,

Here you can find your solution. I couldn't upload the file so you can download it from the next url:

http://www.megaupload.com/?d=33DC6CM7

Change Slider Values based on selections

lucas4bi — Fri, 04 Feb 2011 17:09:00 GMT

Hi martin,

if you create a variable ex. "v_date" and you use it as variable on your slider, then

put this in the "min value" box: =min(Date)

and this in the "max value" box: =max(Date).

then go in the number format sheet (always in object properties) and select DATE as format.

this should work exactly as you want, u can select the year and see only the dates associated to that.

i've tried this on the example you posted before and it works 😉

Change Slider Values based on selections

Mon, 07 Feb 2011 09:00:23 GMT

Thanks for your help,

the half way is gone, but i have another question to this:
If i select something in the date, year or month field, the slider changes to the correct value, but not vice versa. If i select something in the slider, the date field is not showing, what i selected. Is there a solution for this case?

Change Slider Values based on selections

Mon, 07 Feb 2011 09:16:39 GMT

Hi folks,

i searched for a while in this forum and found a good solution provided by Rob Wunderlich in this Thread: http://community.qlik.com/forums/t/22315.aspx?PageIndex=1

Since QlikView V9 you can do this using actions.