Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?
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
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.
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.