Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Maybe someone could help me?
I have a Table with product an order Date und production time
Product |
Production time days |
Order Date |
A |
5 |
01.06.2023 |
B |
6 |
06.06.2023 |
C |
3 |
09.06.2023 |
D |
4 |
14.06.2023 |
And another table with workdays
Workday |
|||||||||||||
|
No I need the delivery date. So I have to check die production time and the workday. Result should be
Product |
Production time days |
Order Date |
Delivery date |
A |
5 |
01.06.2023 |
09.06.2023 |
B |
6 |
06.06.2023 |
19.06.2023 |
C |
3 |
09.06.2023 |
14.06.2023 |
D |
4 |
14.06.2023 |
22.06.2023 |
How could I get this?
Thx. Michael
Hi there!
Check out the function LastWorkDate():
To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!
Cheers,