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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with Set Analysis

Hi Guys,

How do I make the following Set Analysis expression to work?

=Sum( {$< DB={'telcon'}, Part No= - {"ZI","ZP"}> } $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

I need DB= 'telcon' and at the same time Part No <> from 'ZI', 'ZP'

Thanks in advance,

Aldo.

1 Solution

Accepted Solutions
separerl
Contributor III
Contributor III

Hi Aldo !

Try something like this:

=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

Note the brackets around Part No and the placement of the minus-sign

/Pär

View solution in original post

4 Replies
separerl
Contributor III
Contributor III

Hi Aldo !

Try something like this:

=sum( {$<DB={'telcon'}, [Part No] -={'ZI','ZP'}>} $(vOpOrdersAmountBalance)) / $(vSalesDivider1)

Note the brackets around Part No and the placement of the minus-sign

/Pär

mike_garcia
Specialist
Specialist

Hi,

Does the variable $(vOpOrdersAmountBalance) return a Field Name?

Mike

Miguel García
Qlik Expert, Author and Trainer
Not applicable
Author

Yes, it returns a Field Name.

Aldo.

Not applicable
Author

It works,

Thanks,

Aldo.