Hi Sir, i am very new to Qlik and hope you could help resolve this issue similar to calculate different in days: I would like to know from Invoice Date to Receiving Order Date, how long it took to produce a product. the calculation works well if the invoice date is later than order date. However, the result would goes into negative when the receiving order date is greater than invoice date. example: received order on 25th of the month and invoiced on the 1st of next month. hence the result is -24 instead of 5 or 6 days depending on if that month has 30 or 31 (or 28) days in the calendar.
Seeking your expert solution on this issue, thanks for your reading.
