Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Calculate Total Across Rows in Straight Table

Hi All,

Got a problem that's been beat to death on the forums and I'm still stuck! I've got a sample QVW attached of what I'm trying to do, but it's basically this:

NameMonthHours WorkedTotal Hours Worked Per Month by All Employees
Praveen Jan176592
Ashley Jan80592
Kimberly Jan176592
AJ Jan160592
Praveen Feb160530
Ashley Feb55530
Kimberly Feb160530
AJ Feb155530
Praveen Mar150678
Ashley Mar176678
Kimberly Mar176678
AJ Mar176678

I've tried an aggregation formula, but that only provides the total on one row. Is there a way to accomplish this in the table, or should I modify the load script to accumulate hours by month?

Thanks!

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Calculate Total Across Rows in Straight Table

Create a straight table with Month and Name as dimensions and

Sum([Hours Worked]) and Sum(TOTAL <Month> [Hours Worked]) as expressions.

The second expression will give the desired result.

View solution in original post

2 Replies
nagaiank
Valued Contributor III

Re: Calculate Total Across Rows in Straight Table

Create a straight table with Month and Name as dimensions and

Sum([Hours Worked]) and Sum(TOTAL <Month> [Hours Worked]) as expressions.

The second expression will give the desired result.

View solution in original post

Not applicable

Re: Calculate Total Across Rows in Straight Table

Genius, thank you!