topic Can I set a minimum value for a slider object without using variables? in QlikView

Can I set a minimum value for a slider object without using variables?

Tue, 03 Sep 2013 13:42:35 GMT

Hi all,

I added a slider object (Multi value) to select ranges for a field I have (more specifically, I want to have a flexible outlier excluding mechanism, where I can cut off records with particularly high values of the field, and 'play around' with what I deem particularly high).

However, due to the way our data is built, this field has negative values as well, which are meaningless for this particular analysis.

I'd like to set the floor value for this range to be 0, but I don't want to use variables which will mean I'll have to go to the different charts and tables I created and modify the expression (unless I got it wrong).

Anyway to go about it?

Thanks in advance

Re: Can I set a minimum value for a slider object without using variables?

rajeshvaswani77 — Tue, 03 Sep 2013 14:07:16 GMT

You can go to script level and build a table. This table will have the field that the slider will use. This table can have generated values as well. Using loops. Next link this table to your actual table or snapshot.

thanks,

Rajesh Vaswani

Re: Can I set a minimum value for a slider object without using variables?

Tue, 03 Sep 2013 14:10:33 GMT

thanks! anyway to go about it from the design workspace ?

Re: Can I set a minimum value for a slider object without using variables?

rajeshvaswani77 — Tue, 03 Sep 2013 14:14:55 GMT

Other option is choose variables. Create a blank variable and assign that to slider. This will pick teh value based on where the user slides. Also the min and max could be variables. The blank variable i told you can be used in set analyis to control the display. Thus there are two design approaches you can take.

thanks,

Rajesh Vaswani

Re: Can I set a minimum value for a slider object without using variables?

Tue, 03 Sep 2013 14:16:43 GMT

thanks!