topic Re: Display rule using more than 1 variable in the conditions in SAS Visual Analytics

Display rule using more than 1 variable in the conditions

znhnm — Wed, 02 Aug 2023 14:15:40 GMT

Hi,

I am using displays rules on my VA report to add some color coding on my list table. However, I would like to create a display rule, depending on a 2 variable, not 1.

For example, let's say I have age column and also salary column, and also another calculated column called index, where I add the colors.
I would like to fill the index column to green, if age>18 and salary>1000.
I would like to fill the index column to yellow, if age>30 and salary>5000.

So, as you can see the rules depend on both age and salary.

I don't think it is possible to do that on UI, please let me know if it is, but also please let me know if you can think of a workaround to do that.

Re: Display rule using more than 1 variable in the conditions

HunterT_SAS — Wed, 02 Aug 2023 14:38:55 GMT

You should be able to do this by creating a calculated item for your condition first, something like:

IF ( ( 'Age'n > 30 ) AND ( 'Salary'n > 5000 ) )
RETURN 'yellow'
ELSE (
IF ( ( 'Age'n > 18 ) AND ( 'Salary'n > 1000 ) )
RETURN 'green'
ELSE 'red' )

Then use that calculated item in your display rule.

Re: Display rule using more than 1 variable in the conditions

znhnm — Wed, 02 Aug 2023 15:49:18 GMT

It allows me to apply a display rule only using the variables on the list table. I created a calculated item but as long as it is not in the list table, I can't use it to apply a display rule. Thanks for the suggestion, though.

Re: Display rule using more than 1 variable in the conditions

HunterT_SAS — Wed, 02 Aug 2023 15:51:57 GMT

Could you not add the calculated item to the Hidden role for the list table? That should allow it to work in the display rule.

Re: Display rule using more than 1 variable in the conditions

znhnm — Thu, 03 Aug 2023 08:50:17 GMT

This is what I wanted to try also but the list tables do not have hidden roles. 😞

Re: Display rule using more than 1 variable in the conditions

HunterT_SAS — Thu, 03 Aug 2023 12:48:00 GMT

Really? What version of Visual Analytics are you using? List Tables have had the Hidden role for years now.