Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Working with Slider and input boxes ?

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

8 Replies
Highlighted

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

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

Highlighted

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

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

Highlighted
Creator II
Creator II

pls find snapshot

Highlighted
Master III
Master III

Hi Anjee

Please see if the attached helps?

Highlighted
Partner
Partner

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


Highlighted
Creator II
Creator II

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