topic Slider Object in QlikView

Slider Object

Fri, 20 Nov 2009 01:03:01 GMT

Is there a way to set the min and max values of a multi-value slider object based on what is entered into two different calendar objects?

Any help would be much appreciated!

Slider Object

prieper — Fri, 20 Nov 2009 02:47:00 GMT

You can link the min/max-values in the slider to an expression, but this can be also a variable. Thus assign the values from the calendar to the variable and you are basically done.

Peter

Slider Object

Fri, 20 Nov 2009 02:55:21 GMT

Thanks for your response Peter. I am linking the slider to a date field in the data I'm pulling into Qlikview. I am using the variable from the calendar objects as the start/end date to use in a calculation. I tried to use just the slider to accomplish this but my data wasn't always correct. I always need the start and end dates in the calendar object to be equal to the start and end dates on the slider. I probably need a macro to do this. Can you, or anyone else, point me in the right direction?

Thanks!

Slider Object

prieper — Fri, 20 Nov 2009 04:08:49 GMT

The attached should be kind of starter. The slider has a selectable start/end and the result of the slider is handed over into a variable called "dAct". This might then further be used in formulas like SUM(IF(SalesDate = dAct, Sales) or the like

HTH
Peter

Slider Object

Fri, 20 Nov 2009 04:39:36 GMT

Thank you Peter.