Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Peter
Can you share you model?
Steve
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.