topic Re: Populate column rows with column Total in QlikView

Populate column rows with column Total

Wed, 09 Oct 2013 17:04:46 GMT

Hi,

I'm working with a pivot table and need to populate the every row in a column with the columns sum. I've tried using the TOTAL function, but this totals across all dimensions in the pivot table. I've tried aggregating by my dimension of interest, and although this works, the total's only shown at the top of the table, not in each cell of the column.

I've attached an app to better illustrate the issue.

Any advice would be great.

Thanks,

Matt

Re: Populate column rows with column Total

Clever_Anjos — Wed, 09 Oct 2013 17:11:24 GMT

You can restrict what kind of "TOTAL" you want

Sum(TOTAL <Template> Traffic) respects Template

Sum(TOTAL <Template,Day> Traffic) respects Template and Day

Re: Populate column rows with column Total

Wed, 09 Oct 2013 17:21:10 GMT

Thanks! Much appreciated.