Discussion Board for collaboration on QlikView Scripting.
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.....
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
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.
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)|
|=if(Item = 'F',Item)||Sum(1) * RowNo(TOTAL)|
|=if(Item = 'F',Item)||Avg(1)* RowNo(TOTAL)|