BookmarkSubscribeRSS Feed
mhamlett
Quartz | Level 8

using va 7.3

placed a table object on designer

i have two section filters using text boxes defined as parameters

 

i have defined a filter using the parameter.

(comment contains 'parameter1'p OR comment contains 'parameter2'p)

 

the issue is is parameter2 is not coded it seems to select all records from the lasr table anyway because it seems it is selecting all comments that have a blank.  i only want to select records based on a valid entry in the parameter text box.

 

thanks

2 REPLIES 2
EWS
Obsidian | Level 7 EWS
Obsidian | Level 7

Hi mhamlett,

 

You need to identify if parameter2 is missing or not and depending on this execute an expression, see below as example I use UpCase (can also Lowcase) to prevent any mismatching due to upper or lower case used in text(search)field.

 

IF ( 'Parameter2>'p Missing )
RETURN ( UpCase('comment'n) Contains UpCase('Parameter1'p) )
ELSE ( ( UpCase('comment'n) Contains UpCase('Parameter1'p) )
OR ( UpCase('comment'n) Contains UpCase('Parameter2'p) ) )

 

hope it helps

mhamlett
Quartz | Level 8

thought i tried this MISSING feature, but always got some BOOLEAN error.

ill try again

thanks

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 2 replies
  • 1216 views
  • 0 likes
  • 2 in conversation