Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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!
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
Thank you Peter.