RowNo(Total)

Tue, 05 Feb 2013 14:39:20 GMT

Hello,

I have a simple table object with 11 dimensions and 3 expressions and each expression makes a calculation. Whenever all the of the expressions' calculation is equal to 0 (zero), the record is not shown on the table and that is the correct behavior.

Now, the problem I am having right now is that I need show the consecutive of each row but when I add one new expression with the RowNo(Total) expression it adds the records with the previous expressions' calculation equals to zero.

Example:

- This is what it is happening without the RowNo(Total) expression

Dimension 1	Dimension 2	Dimension 3	Expression 1	Expression 2	Expression 3
Aliquam et nisl	vitae ipsum sceler	eget quis est	1	0	3
Ut arcu massa	dictum et feugiat	vulputate in pur	0	0	2
Suspendisse tellus	imperdiet et ultrice	porta sit amet	7	2	0

- This is what is happening with the RowNo(Total) expression

Consecutive	Dimension 1	Dimension 2	Dimension 3	Expression 1	Expression 2	Expression 3
1	Aliquam et nisl	vitae ipsum sceler	eget quis est	1	0	3
2	Duis rhoncus	ipsum nec	felis viverra	0	0	0
3	Ut arcu massa	dictum et feugiat	vulputate in pur	0	0	2
4	Suspendisse tellus	imperdiet et ultrice	porta sit amet	7	2	0
5	Sed eu arcu	et posuere risus	quam at lacus	0	0	0

- What I need:

Consecutive	Dimension 1	Dimension 2	Dimension 3	Expression 1	Expression 2	Expression 3
1	Aliquam et nisl	vitae ipsum sceler	eget quis est	1	0	3
2	Ut arcu massa	dictum et feugiat	vulputate in pur	0	0	2
3	Suspendisse tellus	imperdiet et ultrice	porta sit amet	7	2	0

Thanks for taking the time to read this.

Ryuma,

topic RowNo(Total) in QlikView

RowNo(Total)