Look up the Nearest Percentile Value Based on Expression (Nested Aggregation Issue)
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?