Set Analysis - Exclude

[Anonymous]

Hi

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

[arulsettu]

post your expression it will be easy to answer

[sunny_talwar]

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.

[Anonymous]

Hi Sunny

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

[sunny_talwar · Accepted solution]

Oh got it, may be this:

{<Company = e(Company)>}

[Anonymous]

Hi

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

[sorrakis01]

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

[sunny_talwar]

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.

[Kushal_Chawda]

Try

=sum({1-$}Amt)

or

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

[MayilVahanan]

Hi

Try like this

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