Set Analysis: Respect only some of the selections

[zagzebski]

I need to create an expression that takes two user choices into account, but disregards any other choices.

For instance the two fields that I want to respect are "Year" and "Product" but anything else should be disregarded.

Steve

[danielrozental]

You should use indirect Set Analisys, something like

sum({1<Year=P(Year), Producto=P(Product)>}

[#3]

0 - Represents an empty set

1 - Represents the full set of all the records in the application

$ - Represents the records of the current selection

$1 - Represents the previous selection

$_1 - Represents the next (forward) selection

Bookmark01 - Represents the bookmark ID or the bookmark name

Thats how the identifiers work for qlikview.

So i would $ on year and product, but anything else nothing

it could be sum({<Year={$(somevariable)}, Product={$(somevariable2)}, City=,Country=  }>} Amount)

Then you hold the selection of Year and Product, but see amount on every city and country.