BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rufmau68
Obsidian | Level 7

Hi,

im new in sas va 

 

i need to define a control filter based on the not operand

 

e.g.:

list all product NOT selected by user 

 

if the user select a product list, than prompt filter is based on equal operand, but i need to use it , with the not equal operand

 

it's possible ?

or can i find out any workaround ?

tnks

bye

mauro

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

This appears to be the same question as another post. This is the response I gave for that one. 

 

If I understand what you are asking, I was able to do this by creating a filter on the target object like this: 

 

filter_noIn.jpg

 

This is the text version 

 

( 'Type'n NotIn 'Type Multi-Select'p )

 

Where Type is the data item in my target object, and Type Multi-Select is a multi-select parameter that is assigned to the Parameter role for a List Control.

View solution in original post

1 REPLY 1
Madelyn_SAS
SAS Super FREQ

This appears to be the same question as another post. This is the response I gave for that one. 

 

If I understand what you are asking, I was able to do this by creating a filter on the target object like this: 

 

filter_noIn.jpg

 

This is the text version 

 

( 'Type'n NotIn 'Type Multi-Select'p )

 

Where Type is the data item in my target object, and Type Multi-Select is a multi-select parameter that is assigned to the Parameter role for a List Control.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1015 views
  • 0 likes
  • 2 in conversation