Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datagrrl
Creator III
Creator III

Setting Upper Limit for Selected Values with Input Box

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:

Current.PNG

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

expected0201.PNG

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

2 Replies
marcus_sommer

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

datagrrl
Creator III
Creator III
Author

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.