topic Re: Divide total hours needed to time period in App Development

Divide total hours needed to time period

jw22 — Wed, 17 Jan 2024 15:50:28 GMT

Hello Qlik- Community,

is there a way to devide the needed production hours for a production batch into the planned number of days?

So, for example, i have following table:

For the production "xy" which is planned from 20.02.2024 to 26.02.2024 in total 75 production hours are needed.

Now I want to divide the hours into the single days - should look something like that:

Total needed hours 75 / 7 days = 10,71 hours per day

Thank you!

Re: Divide total hours needed to time period

Rohan — Thu, 18 Jan 2024 06:18:06 GMT

Hi @jw22 ,

Firstly you calculate your daily hours besides your Production Batch itself, by addind a new column :

Production Hours/(Enddate-StartDate) as DailyHours.

Now you have the following columns :

ProductionBatch, StartDate, EndDate, ProductionHours, DailyHours.

xy,20.02.2024,26.02.2024,75,10.71

Now you have to use intervalmatch to generate the dates which fall between your specified date range. & you will get each date row from 20th Feb to 26th Feb with 10.71 infront of it as Daily Hours. Then you can simply add these to your Bar Graph. Try it out & let me know if any issues.

Regards,

Rohan.

Re: Divide total hours needed to time period

Anil_Babu_Samineni — Thu, 18 Jan 2024 08:39:35 GMT

@jw22 make sure you have proper calendar script that shows accumulate for all dates. Otherwise, Simply use this.

Sum(TOTAL [Hours needed])