topic Re: Set Analysis in QlikView

Set Analysis

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Compliments of the season,

I have set of data in the form

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

sunny_talwar — Mon, 11 Dec 2017 13:46:42 GMT

Try this

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

or this

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

Chanty4u — Mon, 11 Dec 2017 13:50:45 GMT

Read this as well

akpofureenughwu — Mon, 11 Dec 2017 13:58:16 GMT

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