topic Re: filtering a listbox in QlikView

filtering a listbox

Thu, 19 Sep 2013 15:58:27 GMT

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

Thu, 19 Sep 2013 16:01:49 GMT

Hi Peter

Can you share you model?

Steve

Thu, 19 Sep 2013 16:04:26 GMT

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.