Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
ramkrishna86
Creator II
Creator 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
Partner - Specialist III
Partner - Specialist III

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
Creator II
Creator II
Author

Can we achieve this using expression in a table?

PradeepReddy
Specialist II
Specialist II

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