Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding Selections with Set Analysis

Hi

Im trying to exclude a couple of selections in my chart expression.

What i currently have is the following, it works, but i dont know how to combine it to force the expression to ignore multiple selections

sum({<coldroom=>} noofbins)

sum({<packed=>} noofbins)

sum({<consigned=> noofbins)

Any help on combining these into one expression? thanx in advance

Labels (1)
1 Solution

Accepted Solutions
Miguel_Angel_Baeyens
Employee
Employee

Hello,

You almost have it:

Sum({< coldroom =, packed =, consigned = >} noofbins)


Hope that helps.

View solution in original post

2 Replies
Miguel_Angel_Baeyens
Employee
Employee

Hello,

You almost have it:

Sum({< coldroom =, packed =, consigned = >} noofbins)


Hope that helps.

Not applicable
Author

excellent, exactly what i looked for thanx