topic aggr and set analysis in QlikView

aggr and set analysis

Fri, 19 Feb 2016 13:02:25 GMT

Hi im trying to get the same result as this formula when i select excluded SiteID=9999

sum(AGGR(Count(DISTINCT SiteID),TransportAssignmentID))

i tried this but it wouldnt help

sum({$<SiteID =-{9999}>}AGGR(Count(DISTINCT SiteID),TransportAssignmentID))

marcus_sommer — Fri, 19 Feb 2016 14:25:13 GMT

Try:

sum(AGGR(Count({$<SiteID -= {9999}>} DISTINCT SiteID),TransportAssignmentID))

- Marcus

sunny_talwar — Fri, 19 Feb 2016 14:25:13 GMT

Try this may be:

Sum({<SiteID =-{9999}>}Aggr(Count(DISTINCT {<SiteID =-{9999}>} SiteID),TransportAssignmentID))