Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

rowno () in script side depending upon specific columns

HI All,

I want to write RowNO () funcion in script side depending upon Workcenter , Funcion Location

Administrator

16 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hi,

Try this, but what is the calculation for Diff ?

T:

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

];

LOAD Date,

if(not IsNull(Peek(Date)),Date&'-'&Peek(Date)) as PrDate

Resident T

Order By Date

;

MK_QSL
MVP
MVP

PFA

Not applicable
Author

Hi Manish,

Please find an attachment file. In that Output column is my expected output.

MK_QSL
MVP
MVP

attachment is missing !

Not applicable
Author

HI Manish,

Please find an attachment in that I want Output column as expected ouptput.

BUt I want it script side.

Not applicable
Author

Hi Manish,

Please find an attachment. I want to do it script side.

Not applicable
Author

Hi All,

Please find an attachment I want output column in script side,.