Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

Average

Dear all,

Kindly advise how to compute ABERAGE in the expression instead of TOTAL.

Correct Answer should be as follows :

 

FactoryRentalRental %ProfitProfit %
Average$939,940.70 20.0%$492,752.28 20.0%
Location 1$818,147.12 17.4%$520,000.0021.1%
Location 2$903,906.40 19.2%$535,361.3821.7%
Location 3$611,100.00 13.0%$270,000.0011.0%
Location 4$969,900.00 20.6%$599,900.0024.3%
Location 5$1,396,650.00 29.7%$538,500.00

21.9%

Thank You

Tracy

1 Solution

Accepted Solutions
sunny_talwar

Check it out

Capture.PNG

Avg(Aggr(sum(Rental), Factory))

Avg(Aggr(sum([Rental %]), Factory))

Avg(Aggr(sum(Profit), Factory))

Avg(Aggr(sum([Profit %]), Factory))

View solution in original post

6 Replies
sunny_talwar

Check it out

Capture.PNG

Avg(Aggr(sum(Rental), Factory))

Avg(Aggr(sum([Rental %]), Factory))

Avg(Aggr(sum(Profit), Factory))

Avg(Aggr(sum([Profit %]), Factory))

rubenmarin

Hi Tracy, if the chart was simple table instead of pivot you can set the totals to calculate as an average in the expression tab (example attached).

For pivot table you need to set the expressions as Sunny posted.

tracycrown
Creator III
Creator III
Author

Dear Ruben Marin

Thank you so much for your kind support, I have learned new feature from you with example even though Sunny had resolved my problem.

Many thanks

Tracy

tracycrown
Creator III
Creator III
Author

Dear all

Kindly advise how to compute Average in column(4) to derive Delta in column(5) by comparing Rental% with Average :

 

FactoryRentalRental %AverageDelta
Average$939,940.70 20.0%20.00%0.0%
Location 1$818,147.12 17.4%20.00%-2.6%
Location 2$903,906.40 19.2%20.00%-0.8%
Location 3$611,100.00 13.0%20.00%-7.0%
Location 4$969,900.00 20.6%20.00%0.6%
Location 5$1,396,650.00 29.7%20.00%9.7%

Thank You

Tracy

sunny_talwar

Here you are

Capture.PNG

tracycrown
Creator III
Creator III
Author

Dear Sunny

Thank you so much, you are very clever and helpful, I have learned something new from you.

Regards

Tracy