
Creator
2023-03-17
11:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Filter data in filter pane and show it in table
Hi,
I have the following table:
rid | eid |
---|---|
null | 1 |
2 | 2 |
3 | null |
4 | 4 |
null | 5 |
I want the table to only show rows with values "1" and "5". In the filter pane, if "2" is chosen, the table should not display anything.
How can I implement this?
Thanks
Labels (7)
Labels
- Subscribe by Topic:
-
dimension
-
expression
-
filter
-
General Question
-
Set Analysis
-
Variables
-
Visualization
626 Views
2 Replies

Specialist
2023-03-18
03:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i Suppose you are talking about 1 and 5 in eid,
Try this :
In you table select eid as Dimension
and as measure write Only({<eid={'1','5'}>}rid)
584 Views

Creator
2023-03-30
03:40 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
no, i want to filter this values out automaticaly, without expilicitly writing '1','5'? Is it possible?
529 Views
