Exclude Condition in set analysis

[#1]

Hello sir,

i wanted to write set analysis for excluding condition . can  anybody tell me how to write it .

Thank u

[jagan · Accepted solution]

Hi Pankaj,

Try -= option

=Sum({<City-={'Mumbai', 'Pune'}>} Sales)

The above expression excludes the sales of Mumai and Pune cities.  Hope this is what yoy are expecting, if not so can you come up with some detailed info.

Regards,

Jagan.

[tresesco]

May be like this?

Sum({<Regoin - ={'A'}>}Sales)      // '-' indicates the exclusion

Or,

if you are talking about indirect set analysis, use e() .

[#4]

You could use the - operator in the set analysis to exclude some conditions from a current selection data:

{$-1<Year={2012}>}

In this example, we are selecting the current selection data($), but excluding all the data from the 2012 year.

[dmohanty]

Suppose you have dimensions Region, Category, Year and some others too with a fact called SALES. If you want to do a aggregation using Set Analysis, it would be like this:

SUM({<Region = , Category = , Year = {'2013'}>}SALES)

Now, what the above expression would do: It would ignore all the values for Region and Category and show only the Sum of SALES that have happened in the Year 2013.

Try using your dimensions like this and let me know if it helped!

Regards!!!

[CELAMBARASAN]

you have to use -=

Sum({<Region-={'Europe'}>} Sales)

[abeyphilip]

Hi,

Something like this?

sum({<status =- {'OK'}>} XX)

Excludes those records with status OK.

Regards,

Abey

[#8]

Hi,

You want to exclude the condition or the values please post your requirement exactly and what type of condition you want to exclude.

Or follow this

Sum({fieldname-={condition}}Fieldname)

-= will exclude the values which satisfies the condition. Qlikview show red lines when you use -= but it works

Try this Hope it helps you

[#9]

Hi,

For the better understanding please find the PFA,

[#10]

Hi,

I would do sth like this:

{set 1} - {set 2}

where

set 1, the members you want to keep (current selection or whatever)

set 2, the members you want to exclude

Fabrice