topic Re: Aggr not working in QlikView

Aggr not working

nithin_miryala — Fri, 06 Apr 2018 20:25:22 GMT

Hi Eveyone,

I have 3 Expressions in my Chart (Nation%, Division% and Practice%),

Both Nation% and Practice% are working as intended but not the Division%

When i select a ProviderNBR the Division line should be the % in the selected providerNBR's Division.

But now it is as similar to Practice% and overlapping on the Practice%

Expression for Division:

= aggr(sum({< EMVisitTypeDSC={'NPV'}>}EMVisitCNT),CPT, DivisionNM)/

aggr(sum({<EMVisitTypeDSC={'NPV'}>}TOTAL EMVisitCNT), CPT , DivisionNM)

Please look at the attached test Application.

Thanks

Re: Aggr not working

vishsaggi — Fri, 06 Apr 2018 20:41:18 GMT

There is no attachment can you please re upload your file.

Re: Aggr not working

vishsaggi — Fri, 06 Apr 2018 20:44:52 GMT

Not sure if this works but just try below:

= Sum(aggr(sum({< EMVisitTypeDSC = {'NPV'} >} EMVisitCNT),CPT, DivisionNM))
/
sum(TOTAL <CPT, DivisionNM> {< EMVisitTypeDSC={'NPV'} >} EMVisitCNT)

Re: Aggr not working

nithin_miryala — Fri, 06 Apr 2018 20:50:34 GMT

Nope this doesn't work.

I have attached the app to main question

Re: Aggr not working

vishsaggi — Fri, 06 Apr 2018 20:59:11 GMT

Check attached?

Re: Aggr not working

nithin_miryala — Fri, 06 Apr 2018 21:27:04 GMT

That is a good one but since we have only one Division in my sample it worked fine.

But if we have more than one division and when we omit the Provider selection how will the expression know to filter to the particular division.

I have loaded one more division into it you will understand what am saying.

Select provider number 2 and see the Division% graph it will combined of both Urology and allergy.

then select Urology you will see difference in the line Division%

Re: Aggr not working

vishsaggi — Sat, 07 Apr 2018 12:57:32 GMT

Sorry Nithin, i left by the time you sent this response. Will look into it and get back.

Re: Aggr not working

sunny_talwar — Sat, 07 Apr 2018 16:14:15 GMT

May be try this

= aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}EMVisitCNT),CPT, DivisionNM)/

aggr(sum({<MeasureNM={'E&M Visits'}, EMVisitTypeDSC={'NPV'}, ProviderNBR=, DivisionNM = p(DivisionNM)>}TOTAL EMVisitCNT), CPT , DivisionNM)

Just an observation... you seem to have unnecessarily made your expressions/dimension complicated using Aggr... I am not entirely sure what you goal is to use Aggr(), but whatever you might be trying to do can be replicated using simpler expression and dimension...