# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Row number for a standard table with suppressed rows

I have a standard table with rows suppressed based on below condition in the expression:

if(exp1<>0, exp1)

if(exp1<>0,exp2)

if(exp1<>0,exp3)

Basically, I am trying to display all the non-zero rows , based on exp1.

Now, when i add row number for this table with ROWNO(TOTAL), it also takes into account row numbers for suppressed rows and the resulting display is not in sequential order.

ex:

RowNo           Dim1     exp1     exp2     exp3

2                    a               1          1          2

4                    b               1          10         5

10                   e               3          5          2

Row no 1, 3, 5-9 are suppressed as they are null

Expected Result:

RowNo           Dim1     exp1     exp2     exp3

1                    a               1          1          2

2                    b               1          10         5

3                   e                 3          5          2

Please let me know how to achieve above expected result?

1 Solution

Accepted Solutions
MVP

Could you upload a small sample QVW that demonstrates how your expressions look like?

Maybe you can use set analysis to limit your record set and dimensional values instead of using the if() statements,

then the rowno() alone should work.

4 Replies
MVP

Which version of QlikView are you using?

At my site, I can't even suppress the rows when using Rowno(TOTAL) in the chart expression.

Could you upload a small sample QVW?

Not applicable

sorry, I missed adding that earlier.I have the same problem as well.When i don't add the rowno expression, i am able to suppress the rows.

When i add rowno(total) expression, i am not able to suppress it.

I tried adding if(exp1<>0, rowno(total)) , result ended up like this

RowNo           Dim1     exp1     exp2     exp3

-                    d               -          -          -

2                   a               1          1         2

-                    aa             -            -         -

4                   b               1          10        5

10                 e               3           5         2

MVP

Could you upload a small sample QVW that demonstrates how your expressions look like?

Maybe you can use set analysis to limit your record set and dimensional values instead of using the if() statements,

then the rowno() alone should work.

Not applicable

thank you. i handled this by limiting records using calculated dimension- combination of aggr and set analysis -> suppressed null values

added rowno() alone as expression and it worked.

Tags