

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated Dimension using ONLY function?
Hi,
I am trying to achieve the following:
Sample Data:
Location | Sublocation | Part |
A | A1 | 12345 |
B | B1 | 23456 |
B | B2 | 12456 |
C | C1 | 14678 |
C | C2 | 18992 |
D | D1 | 18320 |
D | D2 | 10302 |
AB | AB1 | 10320 |
AC | AB2 | 13920 |
AD | AB3 | 10401 |
My Dimensions are:
1. Location
2. Sublocation
However, I do not want to show all Locations as my dimension. I would like to use ONLY function with set analysis ?
I have tried the following but it does not seem to work:
Only ({<{Location-={'AB','AC','AD'}>}Location}
Basically i do not want to show locations with AB, AC, AD. Since this is a sample data set, i am only showing few location. However, i have quite a few locations that i want to show and exclude some. That is why i am going with not contain in set analysis.
Can someone help me on this?
I have attached the sample file.
Thanks,
Vidya
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
if(wildmatch(Location,'AB','AC','AD'),Location)
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It does not work


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
Aggr(Only ({<{Location-={'AB','AC','AD'}>} Location), Location)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this out...added expression with if condition as well as set analysis.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It does not work


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I can't see anything attached


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked for me:
=if(Not Match(Location, 'AB','AC','AD'),Location)
Check suppress when value is null


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would still like to see if this can be achieved using Only function with set analysis

- « Previous Replies
-
- 1
- 2
- Next Replies »