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

[#1]

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?

[#2 · Accepted solution]

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