topic Re: Creating a dynamic listbox not based on a field but an aggr() result in QlikView

Creating a dynamic listbox not based on a field but an aggr() result

Thu, 10 Dec 2015 10:57:58 GMT

Hey everyone,

I am currently trying to implement a from-to selection for a list box (based on an input box referring to two variables).

The listbox presents contains the results of this statement:

=aggr(sum(Sales),CustomerNr)

While I can enter a search string into the listbox like ">500<600", it is tiresome and takes a long time if the number of my aggr-function results is large. I.e. I want to either implement a button that selects all values in the listbox between a certain range.

So I need something similar to this Creating a dynamic listbox based on input box | Qlik Community‌, just with the added auto select and the possibility of operating not on a field but on the result of my aggr-function.

Any nudge in the right direction is appreciated!

Best,

Hans

Re: Creating a dynamic listbox not based on a field but an aggr() result

Gysbert_Wassenaar — Sat, 12 Dec 2015 16:57:54 GMT

You can create a input box (or maybe a slider) with two variable vMin and vMax to enter the range values. And then use those variables in the listbox expression:

=aggr(sum({<CustomerNr={"=sum(Sales)>=$(vMin) AND sum(Sales)<=$(vMax)"}>}Sales),CustomerNr)

Re: Creating a dynamic listbox not based on a field but an aggr() result

Mon, 14 Dec 2015 07:40:51 GMT

Thanks! I already had everything in place but was missing the correct Set-Analysis statement. I guess I need to study more Set Analysis to get things like this right