Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table with an average value in the total row - Need to produce a table with average IN the line data

Hi all,

sorry for not being very specific in my title. I have attached my qvw for you to see. Ignore the synthetic keys at the moment! I'll work on cleaning those up. If you look at the Turnover Figures sheet, I have a straight table at the top which shows department, monthly period, with the number of resources employed in that month and the number of resources who have left in that month.
I have added an expression to calculate turnover, and then another identical expression which I have totalled as an Average.
If I choose one department from a pick list, the bottom row (total line) shows the average correctly.

If I then copy that table, and remove all figures apart from the department and average, the average is not shown as the same figure.

Please can someone have a look at it and let me know how I can get the bottom line average from the first table as a row figure in the second..
I have saved it with the selections to illustrate what I am asking. In the top table the average turnover is 0.00962 I need the bottom table to show this as a line item, but instead it shows 0.0714
Please let me know if you need more info.

Thanks in advance,
Matt

1 Reply
Not applicable
Author

Put this expression in the Second table and it will work fine:

avg(aggr(COUNT(DISTINCT RESOURCE_NAME_TO)/COUNT(DISTINCT RESOURCE_NAME_EMP),Department,PERIOD_NAME))