Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shamiul_islam
Contributor III
Contributor III

Conditional Row Count in Straight Table

I created a straight table where I show Customer wise Sales, Outstanding and Return amount with condition like greater than or less than. But row no are not sequential like 2,4,6. But I want into 1,2,3 sequentially. How can I do that?

If anyone know help me.

Thanks in advance 🙂

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try one of these two solutions.

 

Load 

Alt(peek('NewRowNo'),1)+1 AS NewRowNo

*

From Data;

 

OR

 

Load 

Autonumber(RowNo) as NewRowNo,

*

From Data;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
MVP
MVP

Try one of these two solutions.

 

Load 

Alt(peek('NewRowNo'),1)+1 AS NewRowNo

*

From Data;

 

OR

 

Load 

Autonumber(RowNo) as NewRowNo,

*

From Data;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes