Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there,
I am new to qlikview and trying to figure out how to limit table length using row suppression(or any means, but all I have heard of is row suppresion).
Basically I'm trying to make it so that when a certain expression column calculates to zero that row is removed from my table. I know there are other questions on this forum that potentially answer this question, but I am too new to Qlikview to understand all of the lingo being used in certain posts.
So far the only way that I have heard of is using row suppression, but I am unsure how that works because I still have a lot of rows with all zero's that aren't being suppressed.
Basically my question is twofold. What techniques are there for removing rows with empty data, and how does row suppression actually work?
Thank you in advance for any help!
On the Presentation tab of a table there is an option to Suppress Zero-Values. If all Expressions for a row evaluate to 0 and you have this checked, the row will not display. So yes, to suppress rows you can do this. If you have a "master expression" that you want to control whether a row should display if it is > 0, you can all other expressions reference this expression by its Label name.
example, i only want to show rows where there is revenue
Expression 1: Label = Revenue. Definition: sum(Revenue)
Expression 2: Label = Sales. Definition: If([Revenue] > 0, sum(Sales))