topic Set analysis Set1 AND Set2 in QlikView

Set analysis Set1 AND Set2

Wed, 01 Jun 2011 11:43:12 GMT

I want to make a set analysis expression for the following pseudo code:

(

(Column_A >= 5 AND Column_A <=12)

(Column_C >= 20 AND Column_D <= 50)
)

AND

(

(Column_X <= 5)

(Column_Y >= 9)

)

This would lead to the following two set analysis expressions which should come together with an AND:

{<Column_A = {">=5<=12"}> + <Column_C = {">=20<=50"}>}

AND

{<Column_X = {"<=5"}> + <Column_Y = {"<=9"}>}

How can I replace this AND with the correct syntax in set analysis? Or do I have to rearrange the expression to make it work?

Re: Set analysis Set1 AND Set2

Miguel_Angel_Baeyens — Wed, 01 Jun 2011 12:07:31 GMT

Hello,

It seems to me kind of over-elaborated, but something like the following should work

Sum({(< Column_A = {">=5<=12"} > + < Column_C = {">=20<=50"} >) * (< Column_X = {"<=5"} > + < Column_Y = {"<=9"} >)} Amount)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Set analysis Set1 AND Set2

Fri, 03 Jun 2011 06:54:34 GMT

That does the trick, thanks!

Was struggling with the 1 (set identifier) first. I want to indicate that it represents the full set. Leaving it seems to default to the current selection. Am I right?

Set analysis Set1 AND Set2

Miguel_Angel_Baeyens — Fri, 03 Jun 2011 07:06:55 GMT

Hi,

Well, yes. Preceding the set modifier with the "$" sign or nothing means the current state of selections. Preceding with the "1" instead means all possible values for the dimensions in your chart (or all values if there are no dimensions) regardless of current selections.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica