Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeJones
Creator
Creator

Pivot Table Monday to Friday

I have a pivot table which is linked to a filter pane WeekCommencing that uses the following =WeekStart(Date).  Below shows what it looks like in Excel.  

MikeJones_0-1702033740844.png

Having chosen a week,  I wish to show a table/pivot table on the same sheet that determines the number of widgets made during Monday to Friday divided by the number of days an employee worked during Monday to Friday.

I have tried using ({<WeekDay-={'6','7'}>}Widgets) - Widgets is a master item - to determine the denominator, but it doesn't work.  It pulls through the weekly total.

I can't share my data as I can't create qvf files.

 

 

 

Labels (5)
1 Reply
Anil_Babu_Samineni

You already have shared the data in the above, please share that excel to look. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful