Discussion Board for collaboration related to QlikView App Development.
I want to write RowNO () funcion in script side depending upon Workcenter , Funcion Location
Try this, but what is the calculation for Diff ?
LOAD Workcenter,[Funcional Location],Text(Date) as Date,AutoNumber(RecNo(),Workcenter) as Seq;
LOAD * INLINE [
Workcenter, Funcional Location, Date, Exp
A, X, 02/28/2014,10
B, Y, 03/12/2014,20
C, X, 03/20/2014,30
if(not IsNull(Peek(Date)),Date&'-'&Peek(Date)) as PrDate
Order By Date