topic Issue using Aggr Along with SET Exclusion in QlikView

Issue using Aggr Along with SET Exclusion

nvrphanikumar — Wed, 17 May 2017 14:06:03 GMT

@I have this below expression in the Dashboard,which is working.

Sum({$<[JO Status]={"010 Open"}>} aggr( OPENINGS_CNT,[Job Opening ID]))

I would like to make changes to this such that,When other Values are selected on JO Status,I would like the metric to not change.

Sum({$<[JO Status]=,[JO Status]={"010 Open"}>} aggr( OPENINGS_CNT,[Job Opening ID]))

I cant get this to work

When I don't use Aggr, This calculation below works,It doesn't take filter selctions on JO Status.

Sum({$<[JO Status]=,[JO Status]={"010 Open"}>} OPENINGS_CNT)

Not sure if I have to code it different when using Aggr,Can someone please help ?

stigchel — Wed, 17 May 2017 14:19:39 GMT

Try with

Aggr(Sum({$<[JO Status]={"010 Open"}>} OPENINGS_CNT),[Job Opening ID])

nvrphanikumar — Wed, 17 May 2017 14:36:11 GMT

Since,I have this definition in KPI,Its expecting sum values

so ,I tweaked your code to below,but this isn't getting me right numbers either.

sum(Aggr(Sum({$<[JO Status]={"010 Open"}>} OPENINGS_CNT),[Job Opening ID]))