numbers of hours per week

[capriconuser]

I have this kind of data 

script :

LOAD Id, 
OwnerName, 
Date(AttendanceDay,'DD/MM/YYYY') as AttendanceDay, 
Month(AttendanceDay) as AttendanceMonth,
Year(AttendanceDay) as AttendanceYear,
Week(AttendanceDay) as Week,

Working_hours 

FROM
ar_sheet.xlsx
(ooxml, embedded labels, table is report);

i want to extract numbers of hours per week , per month and per year ..

 how i do this 

AttendanceDay	WorkingHours
11/19/2019	09:00
11/19/2019	09:00
11/19/2019	09:00
11/19/2019	0:00
11/18/2019	8:14
11/18/2019	6:53
11/18/2019	0:00
11/18/2019	10:42
11/18/2019	9:29
11/18/2019	09:00
11/18/2019	09:00
11/18/2019	8:33
11/18/2019	9:33
11/17/2019	8:16
11/17/2019	10:52
11/17/2019	10:18
11/17/2019	10:56
11/17/2019	8:31
11/17/2019	10:40
11/14/2019	0:00
11/14/2019	10:00
11/14/2019	8:53
11/14/2019	8:53
11/14/2019	9:21
11/14/2019	9:02
11/14/2019	9:27
11/14/2019	7:29
11/14/2019	8:31
11/14/2019	8:40
11/14/2019	9:53
11/14/2019	8:37
11/14/2019	8:43
11/14/2019	9:09
11/14/2019	9:11
11/14/2019	9:21
11/14/2019	8:54
11/14/2019	10:01
11/14/2019	8:43
11/14/2019	0:00
11/14/2019	9:11
11/14/2019	8:55
11/14/2019	9:09
11/14/2019	8:52
11/14/2019	8:00
11/14/2019	8:52
11/14/2019	8:40
11/14/2019	9:26
11/14/2019	9:04
11/14/2019	0:00
11/14/2019	9:13
11/14/2019	6:03
11/14/2019	8:32
11/14/2019	8:09
11/14/2019	8:46
11/14/2019	10:00
11/14/2019	4:18
11/13/2019	0:00
11/11/2019	9:29
11/12/2019	8:37
11/13/2019	8:57
11/12/2019	8:51
11/11/2019	8:35
11/12/2019	8:44
11/13/2019	8:29
11/12/2019	7:39
11/11/2019	8:07
11/12/2019	8:34
11/13/2019	9:08
11/11/2019	0:00
11/12/2019	9:58
11/13/2019	8:20
11/11/2019	7:53
11/13/2019	8:54
11/11/2019	9:54
11/12/2019	0:00
11/13/2019	10:44
11/12/2019	9:12
11/11/2019	9:55
11/12/2019	7:32
11/13/2019	8:57
11/11/2019	0:00
11/12/2019	8:51
11/11/2019	9:20
11/12/2019	9:44
11/13/2019	9:36
11/11/2019	0:00
11/13/2019	7:27
11/11/2019	8:19
11/12/2019	9:47
11/13/2019	8:10
11/11/2019	10:24
11/13/2019	9:27
11/11/2019	7:59
11/12/2019	0:00
11/13/2019	7:52
11/11/2019	9:07
11/12/2019	9:51
11/13/2019	7:07
11/12/2019	9:39
11/13/2019	6:12
11/11/2019	9:54
11/12/2019	8:18
11/12/2019	9:30
11/13/2019	9:33
11/11/2019	9:27
11/12/2019	9:57
11/13/2019	9:38
11/11/2019	8:12
11/12/2019	8:45

[capriconuser]

why i get same reusult kindly check application and image

https://www.dropbox.com/s/ju908jx1ec1pup2/1dash.qvw?dl=0

https://www.dropbox.com/s/xaps82qyyo6i0fa/ar.xlsx?dl=0

check jan return result 223 which is correct.. when i select week1 in 1st image then why this shows me wrong result

@sunny_talwar 

[sunny_talwar]

I am not sure I am able to follow... can you directly attach your qvw here.. I am unable to open dropbox.

[capriconuser]

check it

[sunny_talwar]

So, why do you think week1 result is wrong? if 41 is not right, what is the right number and why?

[capriconuser]

correct result is 223 

@sunny_talwar 

[capriconuser]

when i check excel sheet manually this return me result 

against 2018 year is 2266 and against jan 223 and against week1 is 41.. but here month , year and week result is always same which is 41.. why this is happen ?

[sunny_talwar]

But in your image I am seeing 223 for month... and 41 for week1? why do you say that month, week are both showing 41?

[capriconuser]

have you check image 1 which i previously posted .. in that image i select week 1 .. and in last image i did not select week .. image is cropped butsome you check on left there is slight cropped.. 

when i did not select week 1 image is display correct

when i select week 1 result did not show correct

[sunny_talwar · Accepted solution]

I did... but in that image you have made a selection on week1.... if you don't want your month chart to change it's value based on selection in month... then in your expression ignore selection in week field.... 🙂

[Brett_Bleess]

Hey guys, just wanted to check to see if Sunny's final post got you what you needed?  Basically, he was referring to using Set Analysis in the expression I believe, here is a link just in case you need any help with that:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

If Sunny's post got you what you did need, do not forget to return to the thread and use the Accept as Solution button on his post(s) that helped you get things sorted.  This gives credit to the folks posting possible solutions and it also lets other Community Members know what worked, so be sure to come back and take care of things.  If you are still working on things, leave an update on what you need.

Regards,
Brett