topic Re: how to use the same filter for multiple charts on same section in SAS Visual Analytics

how to use the same filter for multiple charts on same section

mhamlett — Tue, 31 May 2016 21:16:11 GMT

i have a drop down with Year values in it. (ie. 2014 2015 2016)

i have two charts on the same tab.

i want the first chart filtered by the value in the drop down (ie. 2016)

i want the 2nd chart filtered by the value -1 in the drop down (ie 2016 -1=2015)

The value in the dropdown is character and a category.

Re: how to use the same filter for multiple charts on same section

TejaSurapaneni — Wed, 01 Jun 2016 05:32:34 GMT

Hi,

Can you please share the two charts info like roles

Thanks & Regards,

Teja Surapaneni

Re: how to use the same filter for multiple charts on same section

vivek_sas — Wed, 01 Jun 2016 06:13:18 GMT

@mhamlett

> Using paramaters it is possible but for that create dropdown list in the canvas only instead of section filter

>Create parameter from Dropdown

>Filter two tabs using filter

>ex- if year_paramteter notmissing

then year = year_parameter

else

year notmissing

> Year = your year field and year_parameter = parameter which we created from dropdown filter

>Use above logic for TAB1 and (Year_parameter -1) for TAB 2

Hope it will help you

Re: how to use the same filter for multiple charts on same section

mhamlett — Wed, 01 Jun 2016 13:50:43 GMT

how do i do math on a parameter. says type mismatch because the year is a category not a measure.

seems i need to convert the year to a number to subtract 1 from it.

Re: how to use the same filter for multiple charts on same section

Sam_SAS — Wed, 01 Jun 2016 14:20:23 GMT

The Year() operator will return the year from a date value as a number.

Re: how to use the same filter for multiple charts on same section

vivek_sas — Wed, 01 Jun 2016 14:31:45 GMT

> convert charcter to numeric in filter only using parse.

>In below year is in character i coverted it in to numeric

IF ( 'year Parameter'p NotMissing )
RETURN ( Parse('year'n, 'NUMX4.') = Parse('year Parameter'p, 'NUMX4.') - 1 )
ELSE ( 'year'n NotMissing )

Re: how to use the same filter for multiple charts on same section

mhamlett — Wed, 01 Jun 2016 15:55:37 GMT

how do you convert a number to character?

Re: how to use the same filter for multiple charts on same section

Sam_SAS — Wed, 01 Jun 2016 16:10:55 GMT

The Format() operator will return a string from a numeric. The name of this is sort of confusing, I know.

Re: how to use the same filter for multiple charts on same section

vivek_sas — Wed, 01 Jun 2016 17:22:06 GMT

Using Format option

Re: how to use the same filter for multiple charts on same section

vivek_sas — Mon, 13 Jun 2016 05:07:31 GMT

Hi @mhamlett

If you found answer to your question . Can you please choose one of the replies as the solution by "Accepting it as a solution"? And perhaps mark the other as helpful by "Liking" it? This will help other community members who have the same question.

Thank you