Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
datagrrl
Contributor 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
MVP & Luminary
MVP & Luminary

Re: Setting Upper Limit for Selected Values with Input Box

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
MVP & Luminary
MVP & Luminary

Re: Setting Upper Limit for Selected Values with Input Box

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

datagrrl
Contributor III

Re: Setting Upper Limit for Selected Values with Input Box

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.