Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I am New To Qlik Sense but am pretty familiar with everything, but I have a task I cant seem to figure out.
I have 3 dates, an Invoice Date, an Order Date, and a Due Date that are all currently linked by order number. The way it currently works is if an order is invoiced, It is seen as revenue, if it is an order that has not been completed and is due in the future it is a firm order. I want to be able to select an order from previous years and show at that time what was currently a firm order after. My idea is filtering by order date, and showing all previous order dates that haven't been invoiced with a due date that is after the filter order date, to show what our firm orders looked like for the rest of the year back then. Any idea on how to do this?
As I understand, you could use set analysis with date conditions, for example:
Count({<OrderDate = {"<=$(=Max(OrderDate))"}>} Distinct OrderID)
This will count orders with order date before to the last selected order date.
JG
I appreciate the response, but more so what im trying to do is select an order date, and show all previous order dates that have a due date that is after the selected order date so i can show the firm orders that we had at that point in time
Then, I suppose you can use a calculated dimension for the Due Date like this:
If(DueDate > Max(OrderDate), DueDate)
JG