Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
sivaprakash_t
New Contributor

Problem with Rowno()

Hi guys,

I'm facing issue to create rowno based on ID. Please check the below image for your reference what i'm expecting output

rowno should starts with 1 for every new ID.  Please help me out...Capture.PNG

Tags (1)
1 Solution

Accepted Solutions

Re: Problem with Rowno()

You can do like below in Preceding Load

AutoNumber(RowNo(), ID) as RowNo

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
4 Replies
prma7799
Honored Contributor III

Re: Problem with Rowno()

Please share some sample data....

Re: Problem with Rowno()

You can do like below in Preceding Load

AutoNumber(RowNo(), ID) as RowNo

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Honored Contributor III

Re: Problem with Rowno()

row.pngOr Please try like this

LOAD * , RowNo();

LOAD *  Inline [

Id,

1,

1,

1,

2,

2,

2,

3,

4

];

daveamz01
Contributor III

Re: Problem with Rowno()

Hi Siva,

You can use AutoNumber(RecNo(), ID) AS RowNo

Regards,

David