topic or in set analysis in QlikView

or in set analysis

jasonseril — Thu, 17 Dec 2009 18:50:23 GMT

Good day everyone,

The set analysis example below returns the sales for current selection, with new selections both in "Year" AND in "Region",

=sum({$<Year = {2000}, Region = {US, SE, DE, UK, FR}> Sales)

My question is how about for the OR, is there a way for this?

Thanks in advance and more pwoer...

Jason

or in set analysis

Thu, 17 Dec 2009 21:27:34 GMT

You can find more examples on page 353 of manual

=sum({$<Year = {2000},Region += {US, SE, DE, UK, FR}>} Sales)

or in set analysis

jasonseril — Fri, 18 Dec 2009 07:30:25 GMT

Hi Irossi,

Thanks for the reply. Basically the set analysis returns the sales with selections both in "Year" AND "Region. What about for "Year" OR "Region"? Is it correct to have:

=sum({$<Year = {2000} OR Region = {US, SE, DE, UK, FR}>} Sales)

Thanks again,

jason

or in set analysis

mike_garcia — Fri, 18 Dec 2009 09:43:54 GMT

Hello,

Maybe what you are trying to accomplish is not really something that you would use Set Analysis for.

Think about it... the variables being set using set analysis are not conditions, what you do with set analysis is narrow your universe of information to something very specific, sometimes regardless your selections. If there was a way of using an OR operator in set analysis, you would have two sets of data... how do you define which one to use in your expression?

What I'm guessing is that you want the expression to be evaluated either when the year selected is 2000 or when selecting some of the specified Regions. If my guess is correct, you can use the function getfieldselections.

Hope this helps.

Mike.

or in set analysis

johnw — Sat, 19 Dec 2009 05:45:14 GMT

An "OR" in set analysis is a union of two sets. You do a union with the "+" operator like so:

sum({<Year={2000}>+<Region={US,SE,DE,UK,FR}> Sales)

or in set analysis

jasonseril — Sat, 19 Dec 2009 08:31:37 GMT

ok, thank you very much.

jason

or in set analysis

prabhu0505 — Thu, 18 Mar 2010 06:01:34 GMT

Please explain with an example, that will help me to implement the concept in my application.

Advance Thanks.

or in set analysis

s_uhlig — Wed, 13 Oct 2010 15:14:57 GMT

Hi John,

could you please verify the sample above, it seems to be a broken feature. It's not working for me in V9R3 and V9R5.

regards

Sven

or in set analysis

Wed, 13 Oct 2010 15:28:00 GMT

Hi there, why dont you try splitting the expression in two, like this:

=sum({ $<Year = {2000}> } Sales) + sum({ $<Region = {US, SE, DE, UK, FR}> } Sales)

Regards

or in set analysis

s_uhlig — Wed, 13 Oct 2010 17:02:56 GMT

ps.:

I've just recognised, it's working again in V9R6.

be aware & happy qliking

Sven

or in set analysis

johnw — Sat, 16 Oct 2010 00:54:57 GMT

Strange, your file is working for me in V9R5. Ah, well. At least it's working for you again in V9SR6.

or in set analysis

Thu, 12 May 2011 11:17:41 GMT

Hai,

how can i place in group instead of single filed in the expression

Thanks

Re: or in set analysis

Hatus — Thu, 14 Jun 2012 10:16:36 GMT

Great! But how would you write a SET with OR and AND conditions?

Like sum({<Year={2000}>+<Region={US,SE,DE,UK,FR}> AND Product={Shoes}> Sales)

Re: or in set analysis

kevinpintokpa — Thu, 26 Dec 2013 19:43:10 GMT

Thanks, this helped me solve a similar problem!