Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not to SUM for an specific Dimension member

Hello

I am using the following to SUM for only an specific dimension member:

=sum( {<Dimension1={Member1}>} Sales)

Now, I want to accomplish exactly the oposite, which is, NOT SUM for Member1

Any ideas??


thanks

1 Reply
thomas_skariah
Creator III
Creator III

Hi,

Try this code

=sum( {<Dimension1-={'Member1'}>} Sales)

Regards,

Tom