Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

LINKTOFILTEREDVIEW action based on same user but in different columns

I have two tables:
1. Users (the KEY COLUMN is "CODICE FISCALE")
2. Events (the Associated columns are: "User1" "User2" "User3" "User4" )

I am creating a view based on table "Users" with a LINKTOFILTEREDVIEW action button,
and when I click this button I would find the Users if it is present in one of "User1" "User2" "User3" "User4" columns.

If I try with
LINKTOFILTEREDVIEW("Events Global", [User1] = [_THISROW].[CODICE FISCALE])
it works, but I would include all the other 3 situation.
And so also  "User2" "User3" "User4"

Basically I would like to find the Users in the entire "Events Global" view, regardless if it is present in the columns "User1" "User2" "User3" "User4".

How could I proceed?

Solved Solved
1 7 288
1 ACCEPTED SOLUTION

And that's why you need to write.. LINKTOFILTEREDVIEW("Events Global", IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4])))

View solution in original post

7 REPLIES 7

Try IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4]))

Hello Aleksi,
thanks for you reply.

I have inserted your code,
but considering that my goal is to open a filtered calendar view from an action,
I have this error:

The expression is valid but its result type 'Yes/No' is not one of the expected types: App

Schermata 2024-01-31 alle 07.13.23.png

I just wrote the IN() part while driving 🙂

Hello Aleksi,
thanks for you reply.

I have inserted your code,
but considering that my goal is to open a filtered calendar view from an action,
I have this error:

The expression is valid but its result type 'Yes/No' is not one of the expected types: App

And that's why you need to write.. LINKTOFILTEREDVIEW("Events Global", IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4])))

Thanks Aleksi!
It works!

Hello Aleksi,
whereas the calendar view issue was solved,
now the problem is that when I select a row in Main Table where there is the Key Column "CODICE FISCALE", if I insert this table in a dashboard view with Interactive mode actived with Inline Events view, on Row Selected I see only some events an not all the events.

For example:
- If a user has 4 events --> if I search the key value in calendar view, the events associated are 4 (and it is correct)

- but if I select the row for that row ---> I have only 1 event in Inline events
  ( it is filtered only for [User3] and so not for also [User1] [User2] [User4] )

Why?


Top Labels in this Space