topic Set Analysis: 'OR' between modifiers in QlikView

Set Analysis: 'OR' between modifiers

Tue, 28 Sep 2010 18:56:04 GMT

From Help Menu for 'Set Analysis'

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

returns the sales for current selection, but with new selections both in "Year" and in "Region".

Here ',' betweent {2000} and Region represents AND or Intersection.

How can I:

return the sales for current selection, but with new selections both in "Year" 'OR or Union' in "Region".

Thanks in advance.

Abi

Set Analysis: 'OR' between modifiers

Tue, 28 Sep 2010 20:10:18 GMT

You could use the Symmetric Difference, but that will fail when both conditions are true. I think you need the Symmetric Difference combined with the Intersection.

It's messy, but I think it would be:

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

I think that should give you the Sales when either condition is met (but not both) combined with the Sales where both conditions are met. Logically, that should give you everything where either condition is met.

Set Analysis: 'OR' between modifiers

johnw — Tue, 28 Sep 2010 23:39:47 GMT

Maybe I missed something, but doesn't that simplify to just the union?

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