topic Re: QlikView script to flow previous month values if current month value is zero in QlikView

QlikView script to flow previous month values if current month value is zero

ritvik4BI — Mon, 15 Mar 2021 12:43:04 GMT

Hi All,

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.

I have attached the excel file FYR.

Re: QlikView script to flow previous month values if current month value is zero

QFabian — Mon, 15 Mar 2021 14:29:11 GMT

Hi @ritvik4BI , please try this :

LOAD
Month,
if( Sales = 0, previous(Sales), Sales) as Sales
FROM [..\Downloads\Scenario101.xlsx] (ooxml, embedded labels, table is Sheet1);

This is the basic example, with previous function ,

Take care about your data types for ensure correct results, and about order logic too.

greetings!