Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue)

johannesm2 — Thu, 19 Mar 2015 21:24:29 GMT

Hello,

I started developing QlikView apps just a few weeks ago, and I'm having trouble with a new requirement. Basically we have 2 fields, Compensation and wRVUs, which can be benchmarked against national healthcare data. Compensation per wRVU is the value that can be benchmarked. The benchmark file has one column for specialty (think of this as a qualifier field) and then separate columns for every percentile up from 10 to 90. How can I find the percentile of a value based on a provider's specialty while avoiding the Nested Aggregation error?

Any help is appreciated.

Thanks!

Johannes

Re: Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue)

ramoncova06 — Fri, 20 Mar 2015 02:24:48 GMT

look into this older post

Aggr() function

topic Re: Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue) in QlikView

Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue)

Re: Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue)