Hide/Filter Blank Row in my Moudle

Highlighted
Occasional Contributor

Hide/Filter Blank Row in my Moudle

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. 

tompatrickting_0-1583647136371.png

 

Thanks in advance for any help.

 

14 REPLIES 14
Highlighted
Super Contributor

Re: Hide/Filter Blank Row in my Moudle

Hi @tompatrickting 

 

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

 

Screenshot_121.png

Screenshot_122.png

Screenshot_123.png

 

Hope this helps!

Thanks

Akhtar

 

Highlighted
Occasional Contributor

Re: Hide/Filter Blank Row in my Moudle

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.

 

 

 

 

 

Highlighted
Master Anaplanner/Community Boss

Re: Hide/Filter Blank Row in my Moudle

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

NonBlank001.png

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)

NonBlank002.png

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.

NonBlank003.png

 

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:

NonBlank004.png

Let's apply the filter from our system module:

NonBlank005.png

We get the desired result.

NonBlank006.png

 


Jared Dolich
Highlighted
Occasional Contributor

Re: Hide/Filter Blank Row in my Moudle

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.

Highlighted
Master Anaplanner/Community Boss

Re: Hide/Filter Blank Row in my Moudle

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

 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: Hide/Filter Blank Row in my Moudle

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

NonBlank007.pngNonBlank008.png


Jared Dolich
Highlighted
Occasional Contributor

Re: Hide/Filter Blank Row in my Moudle

Thanks Jared, this is a great solution.

Highlighted
Occasional Contributor

Re: Hide/Filter Blank Row in my Moudle

Hi @JaredDolich 

 

 

Please share the complete formula in the final boolean.

 

Thanks,

Tom

Highlighted
Master Anaplanner/Community Boss

Re: Hide/Filter Blank Row in my Moudle

@tompatrickting 

Sorry about that. Here's the full formula.

Occasions001.png


Jared Dolich