Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change Slider Values based on selections

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
dennisnet
Partner
Partner

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?

Not applicable
Author

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

Martin

Not applicable
Author

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

lucas4bi
Partner
Partner

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 😉

Not applicable
Author

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?

Not applicable
Author

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.