QlikView script to flow previous month values if current month value is zero
I have two fields- Month and Sales. I have been trying to write the QlikView script for the following scenario:
If for a month, the Sales value is 0, then the previous month's value should flow into it. For example if the Sales for the month June is 0, then the previous month i.e. May Sales value should flow into it.