topic Re: Set Analysis to Exclude particular possible in QlikView

Set Analysis to Exclude particular possible

Anonymous — Mon, 20 Oct 2014 15:02:15 GMT

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.

maxgro — Mon, 20 Oct 2014 15:06:35 GMT

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

Mon, 20 Oct 2014 15:07:29 GMT

Hi,

Try this

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

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

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

MK_QSL — Mon, 20 Oct 2014 15:13:14 GMT

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

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

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

Anonymous — Mon, 20 Oct 2014 15:28:49 GMT

Thanks Rakesh.