Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i have a slider which is using vfromdate and vtodate as variables and ''min value'' as =date(mindate,'MMM DD YYYY')
and "Max Value " as =date(maxdate,'MMM DD YYYY') and "mindate" and "maxdate" are in num values.
now i have an input box for vfromdate and vtodate where i can input the values and which should change the values in slider also and vice versa and user wants to input values in 'MMM DD YYYY' FORMAT ONLY .
now after opening the document,i want the slider to select the mindate and maxdate as the boundary values
Can anyone let me know how to achieve this .
Thanks,
Anjee
So, this is you are looking?
now after opening the document,i want the slider to select the mindate and maxdate as the boundary values
Yes. And when you change value through input box, the slider should get adjusted accordingly and when you slide ,the variable should also change.
Then Try like this
LET vfromdate = Min(Date(Mindate,'YourFormatHere'));
LET vtodate = Max(Date(Maxdate,'YourFormatHere'));
And Then Create Trigger while opening the qvw.
On sheet property ->Trigger-> Edit -> Select in Field -> Specify value of that field '$(vfromdate)'
For Ref, PFA
This is not the thing what i need .
I want the values on slider.
On slider object,it is not working .. when i set triggers on on open....
pls find snapshot
Hi Anjee
Please see if the attached helps?
Hi,
try to initialise the variables in the script as
SET vfromdate =date(mindate,'MMM DD YYYY')
SET vtodate =date(maxdate,'MMM DD YYYY').
It worked for me..
Hi Sasidhar,
Thanks for your reply and it works up to some extent.
when i am changing the slider,vfromdate is changing but vtodate is not changing in input boxes.
also after reopening the document,old selected values should be removed and the slider should be adjusted to min and max values.
Thanks,
Anjee