topic Re: Range of values in Input Box constraints in QlikView https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357752#M416512 <HTML><HEAD></HEAD><BODY><P>Use an expression for the Listed Values option: =Concat(ValueLoop($(vMinYear),$(vMaxYear)),',')</P></BODY></HTML> Mon, 10 Jul 2017 17:32:48 GMT Gysbert_Wassenaar 2017-07-10T17:32:48Z Range of values in Input Box constraints https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357751#M416511 <HTML><HEAD></HEAD><BODY><P>Hello, I have an input box that is holding a year value (vYear). I want to be able to select the possible years in a drop-down, which I can do by going to the Constraints tab of the Input Box and checking the "Predefined Values Only", "Predefined Values in Drop-down", and "Listed Values" checkboxes. I can then set the Listed Values to my range of possible values, such as:</P><P></P><P>2008;2009;2010;2011;2012;2013;2014;2015;2016;2017</P><P></P><P>However, whenever I get updated data, I have to return to this constraint to update it. What I would like to do is be able to dynamically create this range of values by giving a min and max year and then have the range created for me. For instance, if my min year is 2008 and my max year is 2017, then it will create the string above. I already have the min and max values stored in separate variables (vMinYear and vMaxYear), so I just need a way to get this value. Is there an easy way in QlikView to calculate a range like this?</P></BODY></HTML> Mon, 10 Jul 2017 15:00:21 GMT https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357751#M416511 dselgo_eidex 2017-07-10T15:00:21Z Re: Range of values in Input Box constraints https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357752#M416512 <HTML><HEAD></HEAD><BODY><P>Use an expression for the Listed Values option: =Concat(ValueLoop($(vMinYear),$(vMaxYear)),',')</P></BODY></HTML> Mon, 10 Jul 2017 17:32:48 GMT https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357752#M416512 Gysbert_Wassenaar 2017-07-10T17:32:48Z Re: Range of values in Input Box constraints https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357753#M416513 <HTML><HEAD></HEAD><BODY><P>Awesome! I didn't know about the ValueLoop function, but that is exactly what I needed. Thanks Gysbert!</P></BODY></HTML> Mon, 10 Jul 2017 18:14:57 GMT https://community.qlik.com/t5/QlikView/Range-of-values-in-Input-Box-constraints/m-p/1357753#M416513 dselgo_eidex 2017-07-10T18:14:57Z