topic Re: Create iterative numbers in QlikView

Create iterative numbers

X01330132 — Thu, 23 Sep 2021 09:44:41 GMT

Hello,

I am trying to achieve Field2;

Field1 Field2

1 1

2 1

3 1

1 2

2 2

3 2

1 3

2 3

3 3

I tried peek function as well as loops but I couldn't success. I am trying to create page numbers for NPrinting PowerPoint so the tables will fit accordingly.

Thank you!

Re: Create iterative numbers

jyothish8807 — Thu, 23 Sep 2021 10:28:38 GMT

Hi @X01330132 ,

May be like this this ?

T1:
load *,
RowNo() as SiNo,
if(Field1<>previous(previous(previous(Field1))),1,if(Field1=peek(Field1,-3),peek(Field2,-3)+1)) as Field2;
Load * Inline [
Field1
1,
2,
3,
1,
2,
3,
1,
2,
3
];

Re: Create iterative numbers

X01330132 — Thu, 23 Sep 2021 13:43:35 GMT

Worked like a charm, thanks a lot 🙂

Re: Create iterative numbers

Saravanan_Desingh — Thu, 23 Sep 2021 16:40:52 GMT

Try this,

tab1: Load RowNo() As RowID,*,AutoNumber(RowNo(), Field1) As Field2 Inline [ Field1 1 2 3 1 2 3 1 2 3 ];

Re: Create iterative numbers

X01330132 — Fri, 24 Sep 2021 06:59:54 GMT

Also works great, thank you!