topic Re: Qlik Sense Tables - Totals and % change calc in App Development

Qlik Sense Tables - Totals and % change calc

peterkumar — Fri, 11 Oct 2019 19:27:01 GMT

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

Re: Qlik Sense Tables - Totals and % change calc

udayreddy06 — Fri, 11 Oct 2019 21:43:34 GMT

Hello Peter,

Try below expression.

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

Thanks,
Uday

Re: Qlik Sense Tables - Totals and % change calc

peterkumar — Tue, 15 Oct 2019 01:55:03 GMT

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

Re: Qlik Sense Tables - Totals and % change calc

thi_pham — Tue, 15 Oct 2019 04:02:30 GMT

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.