Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Populate column rows with column Total

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

Tags (1)
1 Solution

Accepted Solutions
cuv
Not applicable

Re: Populate column rows with column Total

You can restrict what kind of "TOTAL" you want

Sum(TOTAL <Template> Traffic) respects Template

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

2 Replies
cuv
Not applicable

Re: Populate column rows with column Total

You can restrict what kind of "TOTAL" you want

Sum(TOTAL <Template> Traffic) respects Template

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

Not applicable

Re: Populate column rows with column Total

Thanks! Much appreciated.