Please help with time on shifts calculation in QV.

[#1]

Hello Dear All!

Asking you to help with this.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6242.CH06_5F00_20110207_5F00_130700.xls:550:0]

I have QV file with fileds shown in excel above.

I need to calculate how many hours device will work in day starting from monday.

I have:

week days (CalendarDayOfWeek) = 1,2,3,4,5

work hours planned for this device (Time(Hrs)) = 21.52

hours of possible work time for device in one day (DayWorkTime) = 16

So I need to calculate and show how many hours in days device will be working.

Regarding to data in excel must be something like:

CalendarDaysOfWeek Working

1 16

2 5.52

3 0

4 0

5 0

Hope now its described more clearly.

Thank You!!!

[#2]

Sorry but you question is not very clear to me and I think that I am not the only one 😉

Maybe you could be more clear and tell what you have in Qv.

Martijn

[#3]

I have edited my request. So I think maybe now its more clear to understand.

Thank you!