topic Calculate Total Across Rows in Straight Table in QlikView

Calculate Total Across Rows in Straight Table

Sat, 17 Jan 2015 01:12:40 GMT

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:

Name	Month	Hours Worked	Total Hours Worked Per Month by All Employees
Praveen	Jan	176	592
Ashley	Jan	80	592
Kimberly	Jan	176	592
AJ	Jan	160	592
Praveen	Feb	160	530
Ashley	Feb	55	530
Kimberly	Feb	160	530
AJ	Feb	155	530
Praveen	Mar	150	678
Ashley	Mar	176	678
Kimberly	Mar	176	678
AJ	Mar	176	678

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!

Re: Calculate Total Across Rows in Straight Table

nagaiank — Sat, 17 Jan 2015 02:26:50 GMT

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.

Re: Calculate Total Across Rows in Straight Table

Tue, 20 Jan 2015 17:10:13 GMT

Genius, thank you!