topic Re: Help with Set Analysis in QlikView

Help with Set Analysis

Tue, 28 Jan 2014 17:38:30 GMT

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.

Re: Help with Set Analysis

Colin-Albert — Tue, 28 Jan 2014 17:44:58 GMT

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.

Re: Help with Set Analysis

MK_QSL — Tue, 28 Jan 2014 17:49:07 GMT

Create a Calculated Dimension:

If(Flag = 1, YourDimensionName)

Re: Help with Set Analysis

Nicole-Smith — Tue, 28 Jan 2014 17:50:43 GMT

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)

Re: Help with Set Analysis

Colin-Albert — Tue, 28 Jan 2014 17:52:41 GMT

Another option (again not using set analysis)

=sum(value * flag)