Dear QlikView-Community,
I am looking for a solution regarding the following problem/issue:
I need to calculate costs for working-assignments. I got the start- and enddate, and I know, how much is charged for which hour (e.g. MO-FR, 08.00 - 18.00: 100$/hour, MO-SO, 22:00 - 06:00: 120 $/hour, remaining: 110 $/hour);
How could i accmplish this in Qlik?
Should i split every working-hour into minutes (with iterNo() - so i could match a tariff (tariff/60) to each minute? Or is there a simpler approach?
Greetings
Jakob