Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead 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
swuehl
MVP
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.

View solution in original post

4 Replies
swuehl
MVP
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
Author

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

swuehl
MVP
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
Author

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.