Qlik Sense Tables - Totals and % change calc

[peterkumar]

Hello Qlik Experts,

Many thanks for your time on this!  

In a Qlik sense table, I am doing a count distinct for each cell for each month for department.

The number of totals at the bottom is less because it is doing a count distinct on the Month as opposed to adding count distinct by department per month.  

How do I fix that?

Also, need to add a row at the bottom that shows the % change on the total from the prior month.

Many thanks!

Department	CIO	Jan	Feb	Mar
Sales	John	6	5	6
HR	Susan	20	23	23
IT	Ramesh	2	2	2
Mgmt	Peter	8	9	10
Totals		32	35	39
% Change			9.4	11.4

[udayreddy06]

Hello Peter,

Try below expression.

sum(aggr(expression(),Department, Month))

Thanks,
Uday

[peterkumar]

Thanks Uday!

I solved it be doing a load distinct in the script, so in the viz i do a count (not a count distinct).

It's a straight table and I am trying to add a row below the totals to show the % change in totals from month to month.  The calc is straightforward.  I don't know how to add a new row in a table in Qlik Sense. 

I am getting around it by adding a new table to show the % change from month to month.  Adding a row at the bottom of the above table will look much cleaner.

Thanks again!

Peter

[thi_pham]

I think this extension can help this case : https://developer.qlik.com/garden/5aaf68b9ac897a4420707857

With it, you can add row by measure and columns will be values of dimensions.

Hope it helps.