topic Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4) in SAS Visual Analytics

Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Fri, 29 Aug 2025 09:16:36 GMT

Hello!

I have a little problem with the connection between the variable displayed as a list Month (‘Mese Erog.’) and the variable set as a page filter Year (‘Anno Erog.’).

When I open it, it looks correct like this:

If I select the Month (7, July) is ok:

but when I deselect the Year '2025', the Month is still selected: why?

In this case, I don't have the July total for the two years (2024, 2025), but the overall total for the two years appears, which, given the selection show (of July) is incorrect.

It seems that the Year page filter isn't connected to the Month list filter: how should I connect them? Is this possible?

The correct report (and total of July 2024+2025) should be this one:

Thank you so…

Teo

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

TSBruce — Fri, 29 Aug 2025 11:42:36 GMT

Hi Teo-

It may be helpful to get your report to see how you have things defined. Would you be able to do the following:

1. Open the report in the editor
2. Click on any report object so it is selected
3. Press Ctrl+Alt+B on your keyboard. This will open a new window that has XML text in it.
4. Click the SAVE button here to save this text to a text file.
5. Send the file to this post.

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Fri, 29 Aug 2025 14:59:23 GMT

OK, thanks!
But where do I attach the TXT file?

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

TSBruce — Fri, 29 Aug 2025 15:12:13 GMT

There should be a drop zone under the Body section of the post where you can attach files.

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Fri, 29 Aug 2025 15:30:19 GMT

OK, I tried that place...
but it gives me an error about the extension

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Tue, 02 Sep 2025 10:59:49 GMT

Hi Bruce!

here it is... thx!

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

TSBruce — Tue, 02 Sep 2025 15:49:35 GMT

I am having issues with the XML provided. Would you be able to export the report using Environment Manager and send the resulting json?

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Wed, 03 Sep 2025 08:50:03 GMT

Hi Bruce!

here it is...

Thx!

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Wed, 03 Sep 2025 08:57:47 GMT

Sorry, here's the only one with the page that has the Year/Month filter problem...

thx!

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

TSBruce — Wed, 03 Sep 2025 13:52:53 GMT

You may try disabling the Automatic actions on all objects option to see if that changes behavior. You can define action to the objects you want the filter to affect.

Also, I have tested this in VA8.5 and do not see the same behavior. Given that your environment (VA8.4 on Viya3.4) is currently at Limited Support per https://support.sas.com/en/technical-support/services-policies/sas-viya-3x.html , you may consider updating so you are using an environment that is at Standard Support.

Re: Problem with variable displayed as a list and variable set as a page filter (SAS Viya 3.4)

Teo_ita — Wed, 03 Sep 2025 15:44:35 GMT

Hi Bruce!

In the end, I solved the problem by removing the Actions, as you mentioned, and adding only those related to the two reference tables.

Thank you very much!