Help with Set Analysis

[#1]

Hello all,

In my initial load, I have evaluated a condition and set a flag for each record (0 or 1).  Now I want to create a straight table from these results only showing records where the flag above is "1".  Sounds easy but I can't get it.

Thanks.

[Colin-Albert]

This does not need set analysis.

In your data load rather than setting the flag field to 1 or 0, set the flag to 1 or null.

     if(value = x,1) as flag          // the expression does not have an else value

Then you can add your flag field as a dimension and set the "Suppress When Value Is Null" option on the Dimension sheet.

[MK_QSL]

Create a Calculated Dimension:

If(Flag = 1, YourDimensionName)

[Nicole-Smith · Accepted solution]

Your set analysis should look like this:

{<YourFlagField={1}>}

So your expression should look like this (using whatever calculation you're using):

sum({<YourFlagField={1}>} SomeFieldToSum)

[Colin-Albert]

Another option (again not using set analysis)

=sum(value * flag)