topic Setting variable from slider object in QlikView

Setting variable from slider object

Thu, 13 Oct 2011 15:59:51 GMT

Hi all,

I have a slider/calendar object that allows you to select any month since Jan 2004. I'd like to store the currently selected month in a variable so that I can reference it in a few expressions I'm working on. I've never really worked with variables in Qlikview before, so I have no idea what I'm doing or even where to begin. Any help would be greatly appreciated!

Jacob

Setting variable from slider object

Miguel_Angel_Baeyens — Thu, 13 Oct 2011 16:09:14 GMT

Hi Jacob,

First, create the variable in the Settings menu, Variable Overview. You can crete them as well in the script using LET or SET (the first evaluates the right part of the "=" then stores, the latter only stores as a literal what comes to the right of the "=").

Check this application that uses variables and sliders/calendar objects with a calendar table.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Setting variable from slider object

stevedark — Sun, 04 Dec 2011 23:57:38 GMT

Hi there - I have a video example of using sliders on my web site at http://www.quickintelligence.co.uk/qlikview-videos/ . Hopefuly this may give you some pointers as to what you need to do.

- Steve

Setting variable from slider object

Mon, 05 Dec 2011 06:59:11 GMT

1. create variable as go to document properties -> variables -> click on new button -> name the variable. your variable gets created.

2. right click on sheet -> new sheet object -> select slider/calender object -> on general tab -> click checkbox variables -> select the variable you have created -> on general tab provide min and max value which is the minimum and maximum date which you want to take in calender. Either you can hard code the date or provide any expression.

3. your calender object gets created. select any date from the calender.

4. to see the date take text object and provide expression:

=date(VariableName)

your date gets displayed.

regards

vijit