Set Analysis & Values in Listbox

seb_ma2016 — Fri, 05 Aug 2016 07:19:44 GMT

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

Re: Set Analysis & Values in Listbox

antoniotiman — Fri, 05 Aug 2016 08:17:57 GMT

Hi Seb,

try expression in Listbox

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

Regards,

Antonio

Re: Set Analysis & Values in Listbox

seb_ma2016 — Fri, 05 Aug 2016 08:46:02 GMT

Hi Antonio,

thanks for your replay. That works perfect

topic Set Analysis & Values in Listbox in QlikView

Set Analysis & Values in Listbox

Re: Set Analysis & Values in Listbox

Re: Set Analysis & Values in Listbox