Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: filtering a listbox

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.

2 Replies
Not applicable

Re: filtering a listbox

Hi Peter

Can you share you model?

Steve

Not applicable

Re: filtering a listbox

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.

Community Browser