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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))