
Creator
2023-09-15
05:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use Aggr only on dim
Hello,
I try to use aggr(only(
but I miss something
I would like to remouve Autre
=aggr(only({<[FamilleStat]={"PAC","CHAUDIERES","BIOMASSE"}>}),FamilleStat)
Can you help me ?
Best regard
897 Views
1 Solution
Accepted Solutions

Contributor III
2023-09-15
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can try this expression:
=aggr(only({<FamilleStat -= {'Autres'}>}FamilleStat),FamilleStat)
876 Views
3 Replies

Creator III
2023-09-15
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Louveduval ,
If your aim is to exclude one value from a dimension, you can simply use an IF function combined with qlik objects options :
- Use a calculated dimension like this:
IF(FamilleStat = 'Autres', null(), FamilleStat)
- Disable the option "Include Nul values"
Regards.
880 Views

Contributor III
2023-09-15
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You can try this expression:
=aggr(only({<FamilleStat -= {'Autres'}>}FamilleStat),FamilleStat)
877 Views

Creator
2023-09-15
08:02 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sadly , It doesn't work
862 Views
