If i want to do a chart showing the amount of orders that were delivered the same month they were ordered i will have to put something like this:
Sum(If(OrderMonth=DeliveryMonth, Amount))
But now I have two questions:
-I want to show the sum of amounts from orders that were delivered until 1 month after. I think it should be something like
Sum(If(OrderMonth<=DeliveryMonth-1, Amount))
-And if I find that the second question is how to change the format of the months. As you can see the 4 first digits refer to the year and the 2 last refer to the month. If I do the previous calculus it will omit the orders from december 2019 that were delivered in January 2020. I think there's a way to do it by creating a new field but I wonder if theres a way to do it directly in set analysis.
I will really appreciate your answers so much. Sorry I'm new to Qlik and I'm also not native speaker.