Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am using ROwNo(Total) for row sequence.
In my recent development , i am facing an issue due to RowNo(Total) ,that my table should not show any record if there is no values in dimension but my table is showing 1 row by default......
i dont want to show default 1 row.......i want to show blank or 0 rows.....
Please suggest
I don't quite understand the problem you describe. Can you post a small qlikview document that demonstrates the problem? Or perhaps you can simply use the Calculation Condition to enter an expression that determines if the straight table should be rendered or not.
I am not sure if this is related, but when using Inter-record functions, Suppression of zero values is disabled (and RowNo() is one of the inter-record functions) as per QV Help
Hi,
May be like this ,
=If(YourDimension<>Null(),Rowno(Total))
HTH,
Hirish
Try something like this as expression:
=Avg(1) * RowNo(TOTAL)
But this won't be a continuous counting, right? It will be like 1,2,3,4,6 (assuming 5 is excluded based on selection)?
Are you referring to my suggestion, Sunny?
Continuous counting of what?
As I understood the OP wants to get zero when there are no dimensional lines with values, I assume he still sees NULL and can't suppress it.
I guess I am just trying to understand how Avg(1) is going to help here
Like this (created a dimension that will return just NULL for testing ('F' item does not exist in my record set) 😞
=if(Item = 'F',Item) | RowNo(TOTAL) |
---|---|
0 | |
1 |
=if(Item = 'F',Item) | Sum(1) * RowNo(TOTAL) |
---|---|
0 |
=if(Item = 'F',Item) | Avg(1)* RowNo(TOTAL) |
---|---|