Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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.