Only include dimensions that equal certain values for certain other dimensions in a table

Fri, 04 May 2012 14:10:35 GMT

Hi Community, I have two dimensions. For some values of the dimension, I only want to show if some values other the other dimensions are showing. Is there a way do do this with set analysis, or the script loading with an if statemnt of some kind? Any solution?

Only include dimensions that equal certain values for certain other dimensions in a table

Fri, 04 May 2012 14:23:32 GMT

If you need make it in script and all fields are in the same table:

Table:

LOAD Field1,

Field2,

If(Field2 = 1 or Field2 = 2 or Field2 = 3, Field3, Null()) as Field3,

Field4

From Data.qvd (qvd);

If you need make this in graphic dimensions then.

Dimension_1: Field2

Dimension_2: If(Field2 = 1 or Field2 = 2 or Field2 = 3, Field3, Null())

To can make it in expression by set analysis:

Dimension_1: Field2

Dimension_2: Field3

Expression: Sum({<Field2 = {1,2,3}>} Amount)

Hope this help you.

Regards.-

topic Only include dimensions that equal certain values for certain other dimensions in a table in QlikView

Only include dimensions that equal certain values for certain other dimensions in a table

Only include dimensions that equal certain values for certain other dimensions in a table