Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

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?

Any help is appreciated.



1 Reply
Specialist III
Specialist III

look into this older post

Aggr() function