topic Re: Aggr to show overall county values in QlikView

Aggr to show overall county values

byrnel0586 — Wed, 17 Oct 2018 19:00:41 GMT

Hi all,

I have a straight table that shows summed 'ELIG' totals w/ PCP/Vendor dimensions, but within the same chart I am needing to show the overall county's 'ELIG' values, regardless of PCP/Vendor selection. I have tried set analysis and TOTAL qualifiers to get the result, but am having no luck.

Below are the expressions I am using

'ELIG': Aggr(sum(ELIGIBLE),PCP_ID,_MeasureYearKey) <-- working as I need

'County ELIG': Aggr(sum(ELIGIBLE),County,_MeasureYearKey) <-- giving me values based on the pcp/vendor selection instead of the county's overall sum.

Any help is appreciated.

Re: Aggr to show overall county values

byrnel0586 — Wed, 17 Oct 2018 20:40:31 GMT

I was able to get this to work

=Aggr((SUM({<Year, Month,PCP_ID=,VEND_ID=,PCPwTitle=>}DENOMINATOR)),County,_MeasureYearKey)

Re: Aggr to show overall county values

vishsaggi — Wed, 17 Oct 2018 21:15:16 GMT

may be you can also try like

= SUM(TOTAL <County,_MeasureYearKey> {<Year, Month, PCP_ID=, VEND_ID=, PCPwTitle= >} DENOMINATOR)