topic Re: How to view blank values if text input is blank? in SAS Visual Analytics

How to view blank values if text input is blank?

Sam2022 — Mon, 12 Sep 2022 05:49:22 GMT

Hi,

I want to show blank values for tables or graphs if the text input is blank.

Re: How to view blank values if text input is blank?

JosvanderVelden — Mon, 12 Sep 2022 08:16:26 GMT

I assume the date field is a filter. Can you use a default date that is outside of your date range?
Ex 1JAN1960 or 31DEC2099 as default date.

Re: How to view blank values if text input is blank?

Sam2022 — Mon, 12 Sep 2022 08:49:03 GMT

if the date is outside my range yes the graphs will be blank. however i don't want the text input to have date, i want it to be blank as well

Re: How to view blank values if text input is blank?

Sam_SAS — Mon, 12 Sep 2022 13:29:02 GMT

Hello,

I'm not completely sure why you would want to display missing values for the date.

If you assign a parameter to the text input, and you create a calculated item based on that parameter, I think that it would behave in the way that you want.

Note that creating date parameters is annoying and you must specify a minimum and maximum value. You can just put something like 01JAN1930 and 01JAN2100 if you want.

Let us know if that helps,

Sam

Re: How to view blank values if text input is blank?

Sam2022 — Tue, 13 Sep 2022 08:21:49 GMT

I tried it but it doesn't work, these are the steps i did:

created the parameter:

then assigned it to the text input:

then created a calculated item based on this parameter:

then i added this calculated item to the table:

and now when i remove the date in text input the table gives error:

my point was when the user open the page there is no date shown in text input and table is blank

Re: How to view blank values if text input is blank?

Sam2022 — Tue, 13 Sep 2022 08:28:23 GMT

I want the user see this when opening the page without any data

because the steps which creating parameter the assign to cal item will make the user see a date selected when opening the page

Re: How to view blank values if text input is blank?

Sam_SAS — Tue, 13 Sep 2022 12:29:30 GMT

Hello,

It works for me on Viya 4. From your screen captures, it looks like you have done everything correctly, although it appears you did not set up a filter action between the text input and the table.

Your screen captures show "An error occurred", and I wonder what that error is.

To get a completely empty table when the parameter is not set, create an advanced filter on the Filters pane using the IsSet operator:

( 'Parameter 2'p IsSet )

I'm not sure if that will help until we figure out why you are getting this error, however.

Sam

Re: How to view blank values if text input is blank?

Sam_SAS — Tue, 13 Sep 2022 12:32:29 GMT

Actually, I see one odd thing in your screen captures. You have a datetime parameter, but it has a date format rather than a datetime format. Not sure if that could be an issue.

Re: How to view blank values if text input is blank?

Sam2022 — Wed, 14 Sep 2022 11:05:28 GMT

where do i create the advanced filter? on the text input or table? Also, when i tried to do it either on table or text input the IsSet function gives error which is unknown function.

Re: How to view blank values if text input is blank?

Sam2022 — Wed, 14 Sep 2022 11:08:52 GMT

i made the changes and set the format to date for all, but still i can see the error. (This error only shown while editing the report)

Re: How to view blank values if text input is blank?

Sam_SAS — Wed, 14 Sep 2022 11:49:18 GMT

The filter would go on the table. But if you don't have the IsSet function I think you must have a very old version of Visual Analytics.

Are you on 8.1 or older?

Re: How to view blank values if text input is blank?

Sam2022 — Thu, 15 Sep 2022 04:49:36 GMT

Yes it's old version 7.5

Re: How to view blank values if text input is blank?

Sam_SAS — Thu, 15 Sep 2022 17:27:56 GMT

I get the same error you do when I try this on 7.5.

I think I have a workaround that might help.

1. Edit your parameter and set the current value to be something crazy like 01JAN1900.

2. Ensure the text input has a filter link to the list table on the Actions pane.

3. Make an advanced filter on the list table. Set the expression to select where the parameter value is NOT the current value from step 1 AND not missing. For me, this expression looked like: ( 'Parameter 1'p NotIn ('1JAN1900'd) ) AND ( 'Parameter 1'p NotMissing )

4. Do not include a calculated item based on the parameter in your list table. This will cause the "an error occurred" when the parameter value is not set.

In the screenshot below, the table is filtered when you enter a text value.

When no value is specified, the table is empty and the warning icon says "The filter resulted in an empty set of data".

That is probably the closest we can get to what you want in 7.5.

Sam

Re: How to view blank values if text input is blank?

Sam_SAS — Thu, 15 Sep 2022 17:28:53 GMT

Actually, I have edited the previous post with a working workaround.

Re: How to view blank values if text input is blank?

Sam2022 — Mon, 19 Sep 2022 10:45:48 GMT

Thanks SAM it works, however when user view the report the date is selected. is there any way to make it blank from start? or text input should have date?

Re: How to view blank values if text input is blank?

Sam2022 — Mon, 19 Sep 2022 11:52:57 GMT

ok i managed to make the date blank for user when view report for first time:
( 'Parameter 1'p NotIn () ) AND ( 'Parameter 1'p NotMissing )
without specifying any date 🙂