Assistance with an Expression

Anonymous — Fri, 24 Jul 2015 09:33:43 GMT

I have a set of data where we have log in times for people each day, and a seperate record of their contracted hours.

Example

LoggedIn

01/07/15 503

02/07/15 503

03/07/15 512

04/07/15 200

04/07/15 275

Contracted Hours per day 510

I want to find the % of logged in against the contracted hours, but we have instance where agents log out and back in during the same day (e.g. 04/07/15 data above)

S I want to divide the logged in by the contracted hours per day, but take into account where there may be more than one instance of the same date and therefore still only have a contracted hours of 510 per day.

The expression I have at the moment is

=num(sum(LoggedIn) / count(distinct(date)*ContractedHours*100,'##.##')

This however is not returning the result I expect. If I filter to the 01/07/15 I'm getting 34.98 and not the 98 or 99 that I should be expecting.

Do I need to break up the expression in a different way?

Many thanks in advance

Re: Assistance with an Expression

Gysbert_Wassenaar — Fri, 24 Jul 2015 09:59:47 GMT

See attached qvw.

Re: Assistance with an Expression

robert_mika — Fri, 24 Jul 2015 10:01:40 GMT

tRY:

=aggr(sum(LoggedIn),dATE)/510*100

topic Assistance with an Expression in QlikView

Assistance with an Expression

Re: Assistance with an Expression

Re: Assistance with an Expression