Hide Blank Rows

Occasional Contributor

Hide Blank Rows

Hi,

 

I have a module in which few rows have blank value with changing parameter.

Can i put some formula or any way in which only the rows which are non blank will be displayed irrespective of there changing parameter?

Message 1 of 4
3 REPLIES 3
Highlighted
Community Boss

Re: Hide Blank Rows

Hi, 

 

I've only run into a few cases where I couldn't figure out how to do this...  Here are some ideas:

 

  • If the rows you want to show/hide are line items, then apply a filter to the line item to (for example) only show where not equal to zero, or not blank.
  • If the rows are list items, and the line item is in page items, then the line item can still be filtered for non-zero or non-blank items.

 

If the parameter you are changing is in another line item (or a line item in another module)... then the filtering mechanism to hide/show rows will require a refresh of the dashboard/module in order to update what is being hidden/shown.  Usually, we're talking about a module that's been published to a dashboard... in this case, add a button to the dashboard that is an Open Dashboard action (opening the same dashboard).  this has the effect of refreshing the dashboard.  I usually name this button "Refresh Filters" or something.

 

Let me know if this helps

Message 2 of 4
New Contributor

Re: Hide Blank Rows

Hello,

 

"If the rows are list items, and the line item is in page items, then the line item can still be filtered for non-zero or non-blank items"

 

can you specify how to set the filter. It seems it is mandatory to define the filter in every relevant list item used in the module. I conclude it is not possible to set a zero surpress filter which is dynamic to my actual list item selection?

 

Kind regards,

David Mandl

Message 3 of 4
Community Boss

Re: Hide Blank Rows

@dmandl 

 

If I am understanding you correctly, I believe you can get the results you are looking for in the below.

 

I have created a module with the line items in the Page with a list in the rows.  Notice, every other row is blank or zero.

2019-01-31_11-09-46.png

 

Create a filter within this module or preferrably in another module which is only dimensioned by the List.  Also, just to note, I have Time All Periods turned on in my Time settings.  Create a line item called Filter with the format being a boolean having following formula: Data[SELECT: TIME.All Periods] <> 0.  Set the summary method to ANY.

2019-01-31_11-13-14.png

 

By removing Time from this line item, the filter will not be hardcoded to a specific Time member.  Define the filter as such:2019-01-31_11-14-56.png

 

By applying the filter, the data now looks like the following:2019-01-31_11-15-14.png

 

Hope this helps,

 

Rob

 

 

Message 4 of 4