Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

RowNo(Total)

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 1Dimension 2Dimension 3Expression 1Expression 2Expression 3
Aliquam et nislvitae ipsum scelereget quis est103
Ut arcu massadictum et feugiatvulputate in pur002
Suspendisse tellusimperdiet et ultriceporta sit amet720

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

Consecutive Dimension 1Dimension 2Dimension 3Expression 1Expression 2Expression 3
1Aliquam et nislvitae ipsum scelereget quis est103
2Duis rhoncus

ipsum nec

felis viverra000
3Ut arcu massadictum et feugiatvulputate in pur002
4Suspendisse tellusimperdiet et ultriceporta sit amet720
5Sed eu arcuet posuere risusquam at lacus000

- What I need:

Consecutive Dimension 1Dimension 2Dimension 3Expression 1Expression 2Expression 3
1Aliquam et nislvitae ipsum scelereget quis est103

2

Ut arcu massadictum et feugiatvulputate in pur002
3Suspendisse tellusimperdiet et ultriceporta sit amet720

Thanks for taking the time to read this.

Ryuma,

Community Browser