Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should use indirect Set Analisys, something like
sum({1<Year=P(Year), Producto=P(Product)>}
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.