topic Re: Setting Upper Limit for Selected Values with Input Box in QlikView

Setting Upper Limit for Selected Values with Input Box

datagrrl — Thu, 01 Feb 2018 20:15:54 GMT

Hello-

I am trying to set the upper limit for a field with an input box. I can get this to work through set analysis, but I would prefer the "Selected Values" for this field be based on the entry. I could write the Set Analysis for every formula/object. I could probably write the formula into a variable as well.

I think the solution is probably easy, but it is just not coming to me. I have attached a simple file.

Using Set Analysis this is what I get:

This is what I really want to see (I just selected the values in the list box):

Re: Setting Upper Limit for Selected Values with Input Box

marcus_sommer — Fri, 02 Feb 2018 12:49:40 GMT

I think you could use a selection-action which selects the values in Utilized with an OnChange trigger on the variable and a selection-expression like: <$(vUpperLimit).

- Marcus

Re: Setting Upper Limit for Selected Values with Input Box

datagrrl — Fri, 02 Feb 2018 13:49:35 GMT

Okay, I tried that and wasn't having any luck.I will try changing the syntax again and see if it works.

Okay, the silly thing I was missing on the syntax was this:

='<$(vUpperLimit)'

Does this seem wrong to anyone? It works, so I am leaving it for now.