filtering a listbox

[#1]

Dear all,

I'm pretty new to Qlikview and this question is probably ask a million time, but I did not found a solution.

I would like to display only the Suppliers in a list box, if a certain condition is true.

The condiction is that the number of rejected lots must be greater than zero.

What I did was, I applied the following formula to the listbox:

= if(sum( {<qualityPerformance={'Number of lots/deliveries rej*'}>} Werte) > 0, SupplierName, 'bla')

But I doesn't show anything.

What goes wrong?

Thank for any help

Peter

[#2]

Hi Peter

Can you share you model?

Steve

[#3 · Accepted solution]

RTFM sometimes helps :- )

SOLVED:
=  if(aggr(sum( {<qualityPerformance={'Number of lots/deliveries rej*'}>} Werte), SupplierName) > 0, SupplierName)

If somebody thinks this discussion is not worth being posted, please delete.