Help with a chart expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Assuming I have the following table:

Activity ID	Date	Time Period	% of the day occupied
1	01.01.2018	10-14	50%
2	01.01.2018	10-14	50%
3	01.01.2018	10-14	50%
4	02.01.2018	10-14	50%
5	02.01.2018	10-14	50%
7	02.01.2018	14-18	50%
8	02.01.2018	14-18	50%

I need an expression that calculates the amount of days worked by summing the "% of the day occupied" for each date and time period.
Given the above table, the result of the expression should be 1.5 days/150%(any format works for me as long as the results are good)(50% on 01.01.2018 ,in the 10-14 time period, + 50% on 02.01.2018 ,in 10-14 time period, + 50% on 02.01.2018 ,in 14-18 time period)

Re: Help with a chart expression

sunny_talwar — Thu, 12 Apr 2018 11:21:28 GMT

May be this

Sum(Aggr(Sum(DISTINCT [% of the day occupied]), Date, [Time Period]))

Re: Help with a chart expression

Anonymous — Thu, 12 Apr 2018 12:31:46 GMT

That's it, thanks!

topic Help with a chart expression in QlikView

Help with a chart expression

Re: Help with a chart expression

Re: Help with a chart expression