Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

filtering a listbox


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

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

2 Replies
Not applicable
Author

Hi Peter

Can you share you model?

Steve

Not applicable
Author

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.