Discussion Board for collaboration on QlikView Scripting.
I need to add a new field to and existing table (shown below). The field is calculated using values from the previous record. The problem is that the new field is part of the formula.
The following script gives me this error: '[New Field] does not exist'. Any help would be appreciated.
if(PeriodID = 1, 1, Previous('[New Field]')-Previous('[Budget Contr]')) as [New Field]
Go to Solution.
If(PeriodID = 1, 1, Peek([New Field])-Previous('[Budget Contr]')) as [New Field]