Boolean Filter to match List Subset and List in Module

I am trying to create a filter to apply to 'INP Module - No of Frequencies' so that result below can be achieved but am hitting humps.

If the North Track and East Track in 'ss NE' matches the Track L2 column in SYS Module, then the Expected Result is that Serv under

North Track and Serv under East Track should appear under East Track.

Accepted answers

naushad786

Hi @lps ,

You can create a filter and apply to the result module. for that you need to create filter module which is dimensioned by subset list and serv list. see the below screenshot.

Hope It will help you.

Thanks,

Naushad

All comments

nathan_rudman

if you want to check that an item belongs to a subset, you have two create line items dimensionalized by these subsets, formatted as Bollean and with a formula = TRUE.

You can then check against these line items.

Do this in your list system module.

ps: it is important to name a subset with the following pattern: Name of the list - Name of subset

In your case it would be Track L2 - NE

this way when you are building in blueprint, you can clearly see what list is being used. While this may not seem useful for you now, it will in 6 months time when you'll have forgotten all about the model.

einas.ibrahim

Hi @Nathan

I totally second your advice in naming the subset, especially that there isn’t an easy way to determine which list a subset belongs to in Anaplan as of now.
You can do a manual search through all the lists.

naushad786

Hi @lps ,

You can create a filter and apply to the result module. for that you need to create filter module which is dimensioned by subset list and serv list. see the below screenshot.

Hope It will help you.

Thanks,

Naushad

rob_marshall

Naming conventions can be found here:

https://help.anaplan.com/anapedia/Content/Modeling/Good_Practice/Good_Practice_Naming_Conventions.html

Kanishq17

hi, you can use item(track)=system.track which will identify which serv is in which track and then filter based on that

lps

Hi all
Thank you so much for your advice and suggestions. It works wonders.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…