Assign constant value

Thu, 27 Jul 2017 18:32:29 GMT

Good morning community,

I need your help

A customer has a clothing business and sells it in payments, then the useful life to pay for the clothes is up to a certain period, so if a customer's last payment was on 07/27/2017 and it was for an amount of $ 560 I need That this value will continue to be shown or considered in the following months: 27/08/2017, 27/09/2017, 27/1010/2017, 27/10/2017. I made a master calendar where the date starts me 01/01/2017 until 12/31/2017 and I have a No_ID and only shows the IDs until the Month of 07/27/2017 after 08/27/2017 until 27 / 12/2017 shows me the No_ID in Null, then I want the products that have already finished paying me the last value of the payment considering for the months August, Sept, Oct, Nov and Dec.

Please I have no idea that more help, I've been more than a week without being able to solve this issue

I leave an example of a table showing the needs

Thank you

topic Assign constant value in QlikView

Assign constant value