topic Re: Conditional Row Count in Straight Table in QlikView

Conditional Row Count in Straight Table

shamiul_islam — Sat, 16 Nov 2024 18:56:26 GMT

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 🙂

Re: Conditional Row Count in Straight Table

Vegar — Sun, 15 Mar 2020 11:06:11 GMT

Try one of these two solutions.

Load

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

From Data;

Load

Autonumber(RowNo) as NewRowNo,

From Data;