topic Re: calculate Hours Per Day in QlikView

calculate Hours Per Day

jumiprado — Mon, 04 Jun 2018 18:17:08 GMT

Hi to all!

I have the following table

ID	D.1	D.2	D.3	D.4	D.5	D.6	D.7	D.8	D.9	D.10	D.11	D.12	D.13	D.14	D.15	D.16	D.17	D.18	D.19	D.20	D.21	D.22	D.23	D.24	D.25	D.26	D.27	D.28	D.29	D.30	D.31
AAAA	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2.31	0	0	0	0	0
BBBB	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
CCCC	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
DDDD	9.50	14 F	0	0	8.05	8.00	7.21	9.33	7.18	0	0	0	0	8.02	7.59	8.28	0	0	8.07	8.09	9.03	8.17	9.31	0	0	6.59	14 F	9.20	0	0	0

Where i have for D.1 = DAY 1st of the month the worked hours per ID, and so on for the following days.

In some cases i have something like 14F or other alphanumerical code wich represents the reason for a day off.

I need to sum per MONTH the worked hours for each ID, and mark that days where someone takes a day off.

Thanks!

Re: calculate Hours Per Day

sunny_talwar — Tue, 05 Jun 2018 12:01:22 GMT

What is the expected output for the data you have provided?

Re: calculate Hours Per Day

jumiprado — Tue, 05 Jun 2018 13:03:14 GMT

Hi Sunny T, i need a table with ID, MONTH, Sum(Hours), Count(Days with alphanumeric codes).

The Information in the example is for one month but i have the same table for each month of the year so i need something like this

ID	Month	worked Hrs	Non Worked days
AAA	March 18	80	0
BBB	March 18	60	2
CCC	March 18	20	15

Thanks!

Re: calculate Hours Per Day

sunny_talwar — Tue, 05 Jun 2018 13:15:55 GMT

ID = CCC has all 0, how did you get worked Hrs = 20 AND Non Worked days = 15?

Re: calculate Hours Per Day

jumiprado — Tue, 05 Jun 2018 14:12:52 GMT

I tried to make an example with a resultant table, i need to separate the Hours values (4.25,8.5,7.0, etc) to (14F, 9B2, etc) and count or sum in that way.

Thanks!

Re: calculate Hours Per Day

sunny_talwar — Tue, 05 Jun 2018 19:24:51 GMT

May be like this

Count(If(IsNum(Value), Value))

Count({<Value = {"=IsNum(Value)"}>}Value)