topic Exclude Condition in set analysis in QlikView

Exclude Condition in set analysis

Thu, 26 Sep 2013 06:11:14 GMT

Hello sir,

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

Thank u

Re: Exclude Condition in set analysis

jagan — Thu, 26 Sep 2013 06:38:59 GMT

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.

Re: Exclude Condition in set analysis

tresB — Thu, 26 Sep 2013 06:44:37 GMT

May be like this?

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

Or,

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

Re: Exclude Condition in set analysis

Thu, 26 Sep 2013 06:49:09 GMT

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.

Re: Exclude Condition in set analysis

dmohanty — Thu, 26 Sep 2013 06:55:00 GMT

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!!!

Re: Exclude Condition in set analysis

CELAMBARASAN — Thu, 26 Sep 2013 07:04:01 GMT

you have to use -=

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

Re: Exclude Condition in set analysis

abeyphilip — Thu, 26 Sep 2013 07:04:18 GMT

Hi,

Something like this?

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

Excludes those records with status OK.

Regards,

Abey

Re: Exclude Condition in set analysis

Thu, 26 Sep 2013 07:12:43 GMT

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

Re: Exclude Condition in set analysis

Thu, 26 Sep 2013 07:13:46 GMT

Hi,

For the better understanding please find the PFA,

Re: Exclude Condition in set analysis

Thu, 26 Sep 2013 07:18:26 GMT

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

Re: Exclude Condition in set analysis

nizamsha — Thu, 26 Sep 2013 07:23:00 GMT

sum({$<country={"*"},country-={"UK"}>} amount)

Re: Exclude Condition in set analysis

Thu, 26 Sep 2013 09:49:41 GMT

may be u need indirect set analysis

u can use

sum({$<CompanyName = e({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

here it is sales for customers who are not purchasing Baby Clothes