Hide/Filter Blank Row in my Moudle

[tompatrickting]

Is there a way i can hide/filter those numbered lists in between that has no data.

In the screenshot below, i need to hide numbered list #2, #4 and #5. 

Thanks in advance for any help.

[Akhtar.shahbaz]

Hi @tompatrickting 

Add one filter in your module on list dimension " Is not blank". it will filter only that rows which having value.

Hope this helps!

Thanks

Akhtar

[tompatrickting]

Thanks Akhtar replying to this.

In my screen shot, i only need to hide row #2, #4 and #5. 

Other rows that are blank should still show up, row# 7 to row#10.

[JaredDolich]

@tompatrickting 

I really like @Akhtar.shahbaz idea. Definitely the most expeditious way to filter that list.

In addition, if you need to see the numbered list filtered in a module but be able to reuse the filter and not recalculate, you can create what's called a system module first.

This is the preferred method for long term development using the DISCO methodology.

In the system module you will create a filter similar to the one described by @Akhtar.shahbaz. 

Then when you build the filter in your module you will refer to the system module.

Here's an example.

Say we have a list with empty list items.

Then create a system module that uses the list as its only dimension.

Create the line items using dependent calculations (serial) to support the PLANS methodology (keep it simple and easy to read)

The last line item finally calculates our Boolean and is used as a filter in subsequent modules.

Since you calculated the value here it can be reused and not be recalculated every time for every list item.

Here's a report module that uses this list and has time as another dimension.

Applying the filter directly to this module means it will be for every single cell.

If instead you use the system module as the filter, it only calculates once and is more efficient.

Here's our report module:

Let's apply the filter from our system module:

We get the desired result.

[tompatrickting]

Hi Jared,

I only need to hide those list that are blank in between. 

In the screen shot attached, i only need to hide row #2, #4 and #5. 

Other rows that are blank should still show up, row# 7 to row#10.

Thanks for your help.

[JaredDolich]

@tompatrickting 

Completely understand.

That's why I recommend using the system module.

You can create a line item that formulates the conditions that you want. I just used a non-blank but  you could make it anything like finding the last non-blank list item and unchecking (through formula) all the blank items that are less than that.

Just convert it to a Boolean so you can efficiently use it in a filter.

[JaredDolich · Accepted solution]

@tompatrickting 

Here's an example of what you're looking for.

Module has some list items in the middle that are blank, some at the end that are blank.

To make this really hard, let's assume the worst. The list items in the middle have an index higher than the last non-blank.

Here's our list module. Note the last line item has the correct Boolean filter!

The ones in the middle are unchecked. The ones at the end are checked.

Also, the blueprint if you want some formula ideas.

[tompatrickting]

Thanks Jared, this is a great solution.

[tompatrickting]

Hi @JaredDolich 

Please share the complete formula in the final boolean.

Thanks,

Tom

[JaredDolich]

@tompatrickting 

Sorry about that. Here's the full formula.