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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add particular values sum in a column

Hi friends good day 2 all ,I'm having an issue with expressiopns sum.

Item is a column consists of values as A,B,C,D,E,Class.In pivot table taking dimension as Item and measures as peril,renewal .while sum it up the dimension Item we need  to sum only(A+B+C+D+E) and not include Class in sum(exclude).can any one help on this to do in set analysis to exclude one value in a column..

1 Reply
tresesco
Champion III
Champion III

Sum({<Item-={'Class'}>}measure)            // Note '-' sign before '='