Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis to Exclude particular possible

Hello Expterts,

I want to exclude some fixde  valuse of column from expression.How can I achive this.

I have tried this sum( {$<~[Country] = {*"City of New York"*}>} Sales) which is mentioned in Help.

But this is not working.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try this

sum( {$<[Country] -= {'City of New York'}>} Sales)

Or

sum( {$<[Country] ={'*'}- {'City of New York'}>} Sales)

Or

sum( {$<[Country] -= {"City of New York"}>} Sales)

View solution in original post

4 Replies
maxgro
MVP
MVP

sum( {$<Country= {“*”} – {"*City of New York*"}>} Sales )

Not applicable
Author

Hi,

Try this

sum( {$<[Country] -= {'City of New York'}>} Sales)

Or

sum( {$<[Country] ={'*'}- {'City of New York'}>} Sales)

Or

sum( {$<[Country] -= {"City of New York"}>} Sales)

MK_QSL
MVP
MVP

Use -= .... In set Analysis -= means not equal to....

SUM({<Country -= {'UK'}>}Sales)

will give you SUM(Sales) for all countries except UK

Anonymous
Not applicable
Author

Thanks Rakesh.