topic Re: New Calculated value to combine results in SAS Visual Analytics

New Calculated value to combine results

cuevasj — Thu, 10 Aug 2017 15:27:39 GMT

I have a Category named "Gender" with two values: "M - Male" and "F - Female". I have this Category in a List object. The List object on the current page is Linked to an Info Window. On the Info Window I want to have a Button that shows what was selected on the previous page, as follows (three optoins):

1) "M-Male"

2) "F-Female"

3) "Both"

I created a New Calcuated Item, and attempted to use the following:

if 'Gender'n = 'M - Male' and 'Gender'n = 'F - Female'

return 'Both Selected'

else 'Gender'n

However the 'logic' of the if clause is never true, so I always get 'Gender'n value returned.

Anyone have a way around this? The 'Gender'n field is retaing both the male and female values, but I don't know how to get the logic to work in the If clause.

On version 7.3 Hotfix 04

Thanks.

Re: New Calculated value to combine results

abcde — Thu, 10 Aug 2017 18:10:38 GMT

I don't know if you are familiar with parameters but you need to create a parameter in order to do that and olace it to button under roles.

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#p0qvah37e3ft42n1cbdyymfvbbjl.htm

Re: New Calculated value to combine results

cuevasj — Thu, 10 Aug 2017 18:15:41 GMT

A list box does not allow for parameters.

Re: New Calculated value to combine results

abcde — Thu, 10 Aug 2017 18:17:59 GMT

The parameter should be on the button not the list box in the info window

Re: New Calculated value to combine results

cuevasj — Thu, 10 Aug 2017 18:24:04 GMT

Got it. So I did that, but I still have no way to assign "Both" as an option. I don't want it to display male and female, when neither box is selected in the list box ( or both boxes are selected in the list box) I want the button to display "Both Selected".

Re: New Calculated value to combine results

abcde — Thu, 10 Aug 2017 18:48:13 GMT

Let me work on that and let you know. I think I found a solution by using custom category. I will get back to you

Re: New Calculated value to combine results

cuevasj — Fri, 13 Oct 2017 12:33:34 GMT

Were you able to figure this out?