Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
akpofureenughwu
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

1 Solution

Accepted Solutions

Re: Set Analysis

Try this

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

or this

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

3 Replies

Re: Set Analysis

Try this

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

or this

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

Chanty4u
Esteemed Contributor III

Re: Set Analysis

akpofureenughwu
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