Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Function AGGR and Average


I have an issue with a KPI.

I need to calcul the % of people traited by my investigator.

For this, for each Study, I have the number of patient (of my selection of two investigator), the total number of patient for my study, and the % of inclusion of my investigator in the study , calculed by : Number Patient of this investigator / Number of total of patient for this stud. You can find this in my graphic object ;"


I have the issue when I want calcul for each Investigator, the average in all selectionned study of traited patient in the object graphic "BY INVESTIGATOR".

I succeed to calcul the number of patient by investigator for the selectionned study, but when I want calcul the TOTAL number of Patient in the studies where the investigator participate it's not workd . I use the function aggr by Study, but the result it's false, I don't understand why.

After I need to calculate the % inclusion by Investigator which is calculated by the formul : Numbers Patient of Investigaor / The Average of the Average of Study.

You can find my QVW in this post.

Thanks for your help and I hope we can find a solution.

Kind regards,


1 Reply
Not applicable

Function AGGR and Average


File is too big.

Please try Total(field) instead aggr sum.