Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Seb,
try expression in Listbox
=Aggr(Only({<Net ={"<=$(=varNet)"}>} Order),Order)
Regards,
Antonio
Hi Seb,
try expression in Listbox
=Aggr(Only({<Net ={"<=$(=varNet)"}>} Order),Order)
Regards,
Antonio
Hi Antonio,
thanks for your replay. That works perfect