topic Re: Row number by Dimension in QlikView

Row number by Dimension

ramkrishna86 — Sat, 16 Nov 2024 04:35:13 GMT

Hi,

I want to count rowno by dimension please suggest.

Output will be like below:

Item(Dimension)	RowNo
A	1
A	2
A	3
A	4
A	5
B	1
B	2
B	3
B	4
B	5
B	6
C	1
C	2
C	3
C	4

Thanks

Re: Row number by Dimension

MindaugasBacius — Fri, 01 Feb 2019 08:55:09 GMT

Directory;
LOAD [Item(Dimension)], 
     RowNo,
     AutoNumber(RowNo(), [Item(Dimension)]) as nbr
FROM
Book1.xlsx
(ooxml, embedded labels, table is Sheet1);

There is our expected results:

Re: Row number by Dimension

ramkrishna86 — Fri, 01 Feb 2019 16:54:46 GMT

Can we achieve this using expression in a table?

Re: Row number by Dimension

PradeepReddy — Fri, 08 Feb 2019 03:08:52 GMT

a) I am assuming your are using Straight Table,

Dimensions: Dim1,Dim2

Expression for RowNo: Aggr(RowNo(),Dim1,Dim2)

b) If you are using normal Table, you have to use RowNo()/RecNo() in Load script.

Regards

Pradeep