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?

Answers

  • 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

  • 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

  • @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