topic Re: Set Analysis - Exclude in QlikView

Set Analysis - Exclude

Anonymous — Tue, 29 Dec 2015 12:12:01 GMT

I am creating a straight table and for one of my expressions I want it to include values for all companies except for the company that has been selected. What is the correct set analysis for this?

Thanks

Re: Set Analysis - Exclude

arulsettu — Tue, 29 Dec 2015 12:13:55 GMT

post your expression it will be easy to answer

Re: Set Analysis - Exclude

sunny_talwar — Tue, 29 Dec 2015 12:14:06 GMT

I don't think you need any set analysis for that. That is QlikView's default, i.e., an expression without any set analysis will filter based on the selection.

Re: Set Analysis - Exclude

Anonymous — Tue, 29 Dec 2015 12:16:31 GMT

Hi Sunny

I want the expression to show values for companies EXCLUDED by the selection in the set analysis

Re: Set Analysis - Exclude

sunny_talwar — Tue, 29 Dec 2015 12:18:05 GMT

Oh got it, may be this:

{<Company = e(Company)>}

Re: Set Analysis - Exclude

Anonymous — Tue, 29 Dec 2015 12:19:11 GMT

I just want to show

sum( {<?????????> } Value)

But I don't know what to put in the set analysis to show the values for all companies EXCEPT the one that has been selected

Re: Set Analysis - Exclude

sorrakis01 — Tue, 29 Dec 2015 12:20:26 GMT

Hi,

Try this.

If you don't select always one value selected change the expresion for this one:

If(GetSelectedCount(Company)>0,Sum({1-$}Sales),Sum(Sales))

Regards

Re: Set Analysis - Exclude

sunny_talwar — Tue, 29 Dec 2015 12:23:04 GMT

What you have proposed will be true for any selections made within the application. To be specific just to company, I think this -> Sum({<Company = e(Company)>}Sales) would be a better solution unless he wants it to be everything EXCLUDING all selections.

Re: Set Analysis - Exclude

Kushal_Chawda — Tue, 29 Dec 2015 12:23:07 GMT

Try

=sum({1-$}Amt)

sum({<Company =e({$}Company)>}Sales)

Re: Set Analysis - Exclude

MayilVahanan — Tue, 29 Dec 2015 12:24:39 GMT

Try like this

If(GetSelectedCount(Company)>0, Sum({<Company = e(Company)>}Value), Sum(Value))

Re: Set Analysis - Exclude

Anonymous — Tue, 29 Dec 2015 12:32:26 GMT

HI,

you can try what Kush141087 is proposed.

Thanks.