Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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