Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
johannesm2
New Contributor

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

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

1 Reply
ramoncova06
Valued Contributor III

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

look into this older post

Aggr() function