Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jumiprado
Contributor

calculate Hours Per Day

Hi to all!

I have the following table

 

IDD.1D.2D.3D.4D.5D.6D.7D.8D.9D.10D.11D.12D.13D.14D.15D.16D.17D.18D.19D.20D.21D.22D.23D.24D.25D.26D.27D.28D.29D.30D.31
AAAA00000000000000000000000002.3100000
BBBB0000000000000000000000000000000
CCCC0000000000000000000000000000000
DDDD9.5014 F008.058.007.219.337.1800008.027.598.28008.078.099.038.179.31006.5914 F9.20000

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!

5 Replies

Re: calculate Hours Per Day

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

jumiprado
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

 

IDMonthworked HrsNon Worked days
AAAMarch 18800
BBBMarch 18602
CCCMarch 182015

Thanks!

Re: calculate Hours Per Day

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

jumiprado
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!

Re: calculate Hours Per Day

May be like this

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

or

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