Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Pivot Table Help

Quick background: I have a list of people and their daily hours worked. I made a pivot table showing employees and how many hours they worked per day (Rows:Employee name, Columns:Individual Dates, Measure: Hours worked). I am struggling, however, to make another pivot table in which it sums all 12 hour violations per employee on a weekly basis.

Basically I want a pivot table with my rows to be Employee name, Columns to be Week of year (ie. 1,2,3, etc) and then the measure to be sum of 12 hour violations. Whenever I try and use the hours worked combined with an if function, it returns that they are all 12 hour violations because the employee worked more than 12 hours on the week as a whole.

Any help would be appreciated.

0 Replies