Set Analysis & Values in Listbox

[seb_ma2016]

Hi,

I have a question about the values of the listbox. in my qlikview file I have a table which counts the orders per month und a specific net value.

The net value is set via inputbox and a variable. The counting in the table works fine, but I want to see the orders that were count in a (separate) listbox.

in my example there a three orders in January, but only one that have a net value under 20.

How can I configure my listbox, that it shows only the orders that are counted in the table and are under the set value in the variable?

May be you can help me

thanks,

seb

[antoniotiman · Accepted solution]

Hi Seb,

try expression in Listbox

=Aggr(Only({<Net ={"<=$(=varNet)"}>} Order),Order)

Regards,

Antonio

[seb_ma2016]

Hi Antonio,

thanks for your replay. That works perfect