topic Re: Working with Slider and input boxes ? in QlikView

Working with Slider and input boxes ?

veeranj — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Working with Slider and input boxes ?

Anil_Babu_Samineni — Fri, 14 Oct 2016 06:40:27 GMT

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

Re: Working with Slider and input boxes ?

veeranj — Fri, 14 Oct 2016 06:43:32 GMT

Yes. And when you change value through input box, the slider should get adjusted accordingly and when you slide ,the variable should also change.

Re: Working with Slider and input boxes ?

Anil_Babu_Samineni — Fri, 14 Oct 2016 06:51:06 GMT

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

Re: Working with Slider and input boxes ?

veeranj — Fri, 14 Oct 2016 07:18:11 GMT

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....

Re: Working with Slider and input boxes ?

veeranj — Fri, 14 Oct 2016 07:27:51 GMT

pls find snapshot

Re: Working with Slider and input boxes ?

sasiparupudi1 — Fri, 14 Oct 2016 08:59:05 GMT

Hi Anjee

Please see if the attached helps?

Re: Working with Slider and input boxes ?

vcanale — Fri, 14 Oct 2016 09:14:36 GMT

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..

Re: Working with Slider and input boxes ?

veeranj — Fri, 14 Oct 2016 09:45:52 GMT

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