Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I do an or conditional in set analysis?
example
condition in set analysis
The syntax is broken down into 3 categories:
• Identifiers
• Operators
• Modifiers
Identifiers
Examples:
sum({1} Sales)
Returns total sales within the application, disregarding selections but not
the dimension.
sum({$} Sales)
Returns sales for the current selection, i.e. the same as sum(Sales).
sum({$1} Sales)
Returns sales for the previous selection.
*********************************************************************************
Set Modifiers
A set can be modified by additional or changed selections. Such a
modification can be written in the set expression. The modifier
consists of one or several field names, each followed by selection(s)
that can be made in the field. Modifiers begin and end with angle
brackets <>.
Modifiers - Examples
sum({$<OrderDate = DeliveryDate>} Sales)
Returns the sales for the current selection where OrderDate = DeliveryDate.
sum({1<Region = {US}>} Sales)
Returns the sales for region US disregarding the current selection.
sum({$<Region = >} Sales)
Returns the sales for current selection, but with the selection in “Region”
removed.
sum({<Region = >} Sales)
Returns same as the example above. When the set to modify is omitted, $
is assumed.
sum({$<Year={2000}, Region={“U*”}>} Sales)
Returns the sales for current selection, but with new selections both in
“Year” and in “Region”.
Hi chrisbrune,
Here is OR syntax in set analysis Sum({<Field1={a}>+<Field2={b}>} Sales)
Regards,
Sokkorn