Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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
Partner

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

Hi Manish,

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

MK_QSL
MVP
MVP

attachment is missing !

Not applicable

HI Manish,

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

BUt I want it script side.

Not applicable

Hi Manish,

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

Not applicable

Hi All,

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