How do I do an or conditional in set analysis?

Tue, 21 May 2013 18:18:20 GMT

Re: How do I do an or conditional in set analysis?

Tue, 21 May 2013 18:29:39 GMT

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”.

Re: How do I do an or conditional in set analysis?

Sokkorn — Wed, 22 May 2013 00:55:05 GMT

Hi chrisbrune,

Here is OR syntax in set analysis Sum({<Field1={a}>+<Field2={b}>} Sales)

Regards,

Sokkorn

topic How do I do an or conditional in set analysis? in QlikView

How do I do an or conditional in set analysis?

Re: How do I do an or conditional in set analysis?

Re: How do I do an or conditional in set analysis?