Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ramkrishna86
Contributor II

Row number by Dimension

Hi,

I want to count rowno by dimension please suggest.

Output will be like below:

Item(Dimension)RowNo
A1
A2
A3
A4
A5
B1
B2
B3
B4
B5
B6
C1
C2
C3
C4

 

Thanks

3 Replies
MindaugasBacius
Valued Contributor III

Re: Row number by Dimension

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:

Screenshot_1.jpg

ramkrishna86
Contributor II

Re: Row number by Dimension

Can we achieve this using expression in a table?

pradeepreddy
Valued Contributor II

Re: Row number by Dimension

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