A method to create customized data filter

[Evendo]

Hi!

My intention is creating a filter using data from 2 tables [User] and [Tag] with n:n relationship.

By that, when register a user (which will add data to [User] table), I can select multiple different tags (which already registered in [Tag] table, or I can add new if needed). In other hand, a tag can be selected/used by many different user. I already achieved this by using a Ref EnumList for [Tag] column at [User] table (to show multiple selection pulldown for tag at user input form).

However, I'm having problem with filtering.

I know that to display filtered data, I should create a Slice with filtered condition. But what condition should I use when a user could have multiple tags?

Furthermore, as Ref EnumList is display as Text in main [User] view, is there a way to display it as Link, separated one by one (in case of multiple tags), by that when I click the tag, it will filter User data with selected tag condition?

Hope I could receive some advices. Thanks so much!

[AleksiAlkio · Accepted solution]

LINKTOFILTEREDVIEW() action is one option. If you need to show all tags, you can use something like LINKTOFILTERDEVIEW("Tags",IN([TagID],[_THISROW].[Tags]). If you need to have one action for each of your selection, then you would need to use LINKTOFILTEREDVIEW("Tags",[TagID]=INDEX(SORT([_THISROW].[Tags]),1)) and then hide other actions away with the condition if you have less than 2 selections.

[Evendo]

@AleksiAlkio Thanks so much for advices about using LINKTOFILTEREDVIEW()

In my case, data table contents records having multiple tag values, delimited by comma ",".

Now I have a filter page which end-users could be select multiple choice for tag linked a table to manage users' filter choice.

Is there a way to compare and filter data records matching users' choice? I'm now having problem with this, that is only filtered correctly with data having single tag but not multiple.

For example, I having 4 records

1 yellow,red,blue

2 violet

3 blue,yellow

4 grey,blue

Then if a user choice to filter record with 2 different tags "yellow,blue", I want to filter and show record 1, 3 and 4