Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Assign constant value

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

0 Replies