Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

App Development

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!

Who Me Too'd this solution

Vegar
MVP
MVP

I don't have the tool to open your sample qvw at the moment 😔,  but  the looks of your Excel I suggest that you have trouble getting the correct average due to one row with no value.

Try these expressions

  • avg(Rental)/sum(total Rental)
  • avg(total Rental)/sum(total Rental)
  • (avg(Rental)/sum(total Rental))-avg(total Rental)/sum(total Rental)

View solution in original post

Who Me Too'd this solution