Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please help me,I come from China, English is not good,the question is about table box

example:

load * inline

[field1,field2

A1,B1

A2,B2

A3,B3

];

now: I want to show a table box in the sheet like this:

the table box like this:

rownumber field1 field2

1,A2,B2

2,A3,B3

Mainly I want to add a number before each line as a line number, starting with 1?

Can anyone help me? Thank you
3 Replies
Not applicable
Author

tIf this is a StraightTableBox I think you can use the function RowNo() as expression and put it in front of your dimensions.

Not sure if this can be called in a TableBox though.

Not applicable
Author

Thank you,Smile[:'(],but i can only select table box,and i don't find how to set in the table box

Miguel_Angel_Baeyens

You cannot add expressions (in version 9 at least -think of it as a listbox that shows more than one field) in a TableBox, since it lists the values for the fields you put on it. Moreover when this field is actually an expression, since you don't want to have the record number rather than the actual number of rows for the table. A straight table with field1 and field2 as dimensions and

RowNo(TOTAL)


as expression will do what you want.

Regards