Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

seb_ma2016
New Contributor

Set Analysis & Values in Listbox

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

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Set Analysis & Values in Listbox

Hi Seb,

try expression in Listbox

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

Regards,

Antonio

2 Replies
antoniotiman
Honored Contributor III

Re: Set Analysis & Values in Listbox

Hi Seb,

try expression in Listbox

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

Regards,

Antonio

seb_ma2016
New Contributor

Re: Set Analysis & Values in Listbox

Hi Antonio,

thanks for your replay. That works perfect

Community Browser