Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

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

10 Replies
johnca
Specialist
Specialist

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)