Dynamically set a variable from a slider

Wed, 25 Nov 2020 16:16:04 GMT

Good morning.

I have to set a variable from a slider object.
As you can see in this picture I have a chart and a slider and my target is to set a finishInvestment variable when one finishes to slide the slider; for example in the picture I have to set finishInvestment variable to 2009-08-03:

What can I do to set this variable from the slider?

I'm using a personal edition and I am not able to open qlikview file, so maybe you can use some pictures instead of attach qlikview file.

Thank you.

Re: Dynamically set a variable from a slider

swuehl — Tue, 12 Apr 2016 14:12:43 GMT

You are talking about a QlikView variable? Or a field value you want to select? I assume first.

1) Create a variable in Settings - Variable Overview, e.g. called vDate

2) Create a slider:

Min Value:

=MakeDate(2009,1,1) //or whatever date you want your slider to start with

Max Value:

=MakeDate(2009,12,31) // or whatever date you want your slider to end with

Static step of 1

Override document settings on number tab and select Date as format

This should display your slider and you should be able to assign the date value to your variable vDate by moving the slider.

Note that the variable value will be the numeric date value, but this shouldn't be an issue. You can use the numeric value in any QV date function, e.g. in formatting function Date():

=Date(vDate)

Hope this helps,

Stefan

topic Re: Dynamically set a variable from a slider in QlikView

Dynamically set a variable from a slider

Re: Dynamically set a variable from a slider