topic Set Analysis in QlikView

Set Analysis

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

Please help me on the below requirement.

In a Straight Table I have Three dimensions named Grouping, Metric and Number as like below.

When Operation= Met35.1 and Met35.2 then correspoding records need to avoided and When operations=Met 35.6 then need to keep

those records in the result.Please find the expected result below.

Anonymous — Mon, 23 Oct 2017 13:46:07 GMT

Hi,

try this :
if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),null(),sum(Number))

No need using set analysis I think.

sunny_talwar — Mon, 23 Oct 2017 13:53:39 GMT

Is this the same thing as this?

sudeepkm — Mon, 23 Oct 2017 14:04:30 GMT

another approach could be like below.

you can create a flag in the load script and can use that flag in the UI expression instead of applying the if condition.

at load script:

if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),0,1) as GrpMetricFlag

from <your source>;

Then in UI chart expression you can do:

sum({<GrpMetricFlag={1}>}Number)

this approach could perform better in case of large volume of data.