topic change in the script in QlikView

change in the script

Anonymous — Tue, 09 May 2017 06:09:46 GMT

i have these code of line used previously in my application:

IF( = PREVIOUS() AND = PREVIOUS([y]),
(-PREVIOUS())/([Datefield]-PREVIOUS([Datefield])),0) AS W,

above formula is calculating the value of w ,but in start of the quarter its giving 0

now i want to replace the (0) it in such a way that it should calculate based on average of next few values based on y

Re: change in the script

ahaahaaha — Tue, 09 May 2017 06:43:06 GMT

If the following values are required for the calculation, you must first load them, and then reload the internal table once again to calculate the required values.

Re: change in the script

Anonymous — Tue, 09 May 2017 07:59:34 GMT

i didnt get you

Re: change in the script

Siva_Sankar — Tue, 09 May 2017 08:16:12 GMT

Check Get previous row value when the value is null and Check if Previous Previous field is null

Siva

Re: change in the script

Anonymous — Tue, 09 May 2017 08:30:22 GMT

syntax plz