Set Analysis

[#1]

Hi All,

I am trying to get my head around set analysis. Tom Mackay has created a very useful pdf on set analysis within QlikView (attached). It discusses the three elements of set analysis (Identifiers, Operators and Modifiers).

In his example he shows a couple of examples for Identifiers:

sum({1} Sales)

Then a couple of examples with operators and identifiers:

sum({1 - $} Sales)

Then a couple of examples with modifiers.

sum({1<Region = {US}>} Sales)

The document doesn't seem to have any that include both operators and modifiers. Is this possible? For example can I create an expression that is the Sum of all sales within the [Region] "US" and aren't [SalesProductType] of "Toys"?

I'm just trying to make sure I fully grasp the concept and wanted to check if this type of expression is possible?

Thanks

Dan

[johnca]

Hi Daniel,

This simple set analysis should do just what you asked (I think); Sum of all Sales in the US that are not Toys.

Sum({<Region = {'US'},SalesProductType -= {'Toys'}>} Sales)