topic Re: Adding a calculated row to a pivot table in QlikView

Adding a calculated row to a pivot table

Fri, 18 Oct 2013 22:45:33 GMT

I have a pivot table that i would like to add an extra row with a calculation. I need to divide 2 specific rows in the table to get the calculation. Any ideas on how to do this? Nothing I have tried seems to work. First, any calculated expressions always appear as columns. Second, I can't seem to figure out how to reference specific rows for the calculation.

I attached an image.

Thanks in advance

Re: Adding a calculated row to a pivot table

Gysbert_Wassenaar — Sat, 19 Oct 2013 16:42:44 GMT

You can reference specific rows, but you can reference specific dimension values and use the Total row for a custom calculation. See attached example

Re: Adding a calculated row to a pivot table

Sat, 19 Oct 2013 16:50:06 GMT

Thanks...i'm not sure I understand how Dimensionality works. Can you give an explanation of what's going on in your calculation?

Also, how do you make the expression "Calculated Row" appear as a row instead of a column?

I get zero for my calculations...looks like dimensionality is always one in my table.

Re: Adding a calculated row to a pivot table

Gysbert_Wassenaar — Sat, 19 Oct 2013 17:15:26 GMT

See these two blog posts:

Re: Adding a calculated row to a pivot table

Sat, 19 Oct 2013 17:27:07 GMT

ok...got it now. I see what you meant by using the totals row.

Thanks so much for your help!!!

Re: Adding a calculated row to a pivot table

Tue, 22 Oct 2013 19:58:53 GMT

How would I add other calculated rows? So, that I have more than 1 calculated row.

Re: Adding a calculated row to a pivot table

Wed, 23 Oct 2013 01:15:48 GMT

I tried it with a calculated dimension and it works but I can't get the total to work across the rows. The calculation is correct for each row but the with show partial totals turned on, it is blank for each row. I used aggr with the date as the dimension.