# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Contributor

## calculate Hours Per Day

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!

Tags (3)
5 Replies
MVP

## Re: calculate Hours Per Day

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

Contributor

## Re: calculate Hours Per Day

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!

MVP

## Re: calculate Hours Per Day

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

Contributor

## Re: calculate Hours Per Day

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!

MVP

## Re: calculate Hours Per Day

May be like this

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

or

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