Employee cost per hour

QlikCommSa — Tue, 28 Jun 2022 13:01:46 GMT

Hello,

I want to evaluate the costs of an employee per hour. I know his time of arrival and his time of departure and what his wage per hour ist.

Now I want to visualize this in a bar chart, where I filter on a day. On the x-axis I have the hours of the day. The bars are as high as the costs of the employee in the particular hours.

For example: Anna arrives at 8:30 and leaves at 10:15. Her hourly wage is 20 €. The bar chart has 3 bars:

8: 10 €

9: 20 €

10: 5 €

I guess I have to multiply the rows in the script editor to have one row per hour with the corresponding salary. But I can't find a way to solve it. Do I have to use interval match? Or a loop?

I'm using Qlik Sense Version Feb 22.

Thanks in advance!

topic Employee cost per hour in App Development

Employee cost per hour