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! Go to Solution.
And that's why you need to write.. LINKTOFILTEREDVIEW("Events Global", IN([_THISROW].[CODICE FISCALE],LIST([User1],[User2],[User3],[User4])))
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
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?
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |