Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
chapil
Contributor III
Contributor III

Use SET ANALYSIS as a dimension filter

Hello everybody, 

I have succeed to replace a IF by a pick(wildmatch(CODE,'4'))  in a filter object 

Cause I wanted only this value CODE=4  print ! 

Now I'm trying to do the same but to select 2 different code CODE=4 & CODE=1 

Is this possible with the pick(wildmatch()) ? 

 

I'm sure there is a simple way to do it, thanks for your help ! 

 

1 Solution

Accepted Solutions
Digvijay_Singh

Are you trying to use calculated dimension in the chart?

Not sure but may be something like this - 

=Aggr(Only({<CODE={1,4}>}CODE),CODE)

View solution in original post

2 Replies
Digvijay_Singh

Are you trying to use calculated dimension in the chart?

Not sure but may be something like this - 

=Aggr(Only({<CODE={1,4}>}CODE),CODE)

chapil
Contributor III
Contributor III
Author

Thanks, it works with quotes for my use case 

Thanks a lot @Digvijay_Singh