Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

singhcv123
New Contributor II

Rowno(Total) issue in qlikview straight table

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

8 Replies
MVP & Luminary
MVP & Luminary

Re: Rowno(Total) issue in qlikview straight table

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.



talk is cheap, supply exceeds demand

Re: Rowno(Total) issue in qlikview straight table

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

Capture.PNG

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/InterRecordFuncti...

hirishv7
Honored Contributor

Re: Rowno(Total) issue in qlikview straight table

Hi,

May be like this ,Rowno(Total) Based on Dimension.PNG

=If(YourDimension<>Null(),Rowno(Total))

Inter-Record Functions

HTH,

Hirish

“Aspire to Inspire before we Expire!”
MVP
MVP

Re: Rowno(Total) issue in qlikview straight table

Try something like this as expression:

=Avg(1) * RowNo(TOTAL)

Re: Rowno(Total) issue in qlikview straight table

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)?

MVP
MVP

Re: Rowno(Total) issue in qlikview straight table

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.

Re: Rowno(Total) issue in qlikview straight table

I guess I am just trying to understand how Avg(1) is going to help here

MVP
MVP

Re: Rowno(Total) issue in qlikview straight table

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)