# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Contributor III

## Set Analysis

Compliments of the season,

I have set of data in the form

S/NCompanyAmount
1Sam 2000
2Luke1000
3Jack1200

Using the set analysis,

To calculate amount for sam company

Sum({\$<Company = {'Sam'}>}[Amount])  === correct

I want to calculate all company but sam..

Sum({\$<Company <> {'Sam'}>}[Amount])  === I got incorrect expression

I don't want to use

Sum({\$<Company = {'Jack', 'Luke'}>}[Amount])  because in the real data.. I have millions of companies

Regards

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Set Analysis

Try this

Sum({\$<Company -= {'Sam'}>}[Amount])

or this

Sum({\$<Company = e({<Company = {'Sam'}>}Company)>}[Amount])

3 Replies
MVP

## Re: Set Analysis

Try this

Sum({\$<Company -= {'Sam'}>}[Amount])

or this

Sum({\$<Company = e({<Company = {'Sam'}>}Company)>}[Amount])

Esteemed Contributor III

Contributor III

## Re: Set Analysis

Thank you Sunny for your prompt response as always. Thank you for your contribution in 2017.

And to all the leading contributors in this community, I salute you.

Regards