BookmarkSubscribeRSS Feed
Sanjeev
Fluorite | Level 6

I have a LASR table containing multi-lingual data (English and French) and would like to build a report that dynamically switches between French and English.

Ideally, I would like to have a "custom" language prompt that drives which column to use (French or English).

Can this be done in Visual Analytics? Or this even the best way to achieve this functionality?

I have seen the locale setting in the SAS VA preferences. Perhaps I should be using this setting but am unsure how to reference this setting from within the report designer.

4 REPLIES 4
justin_sas
SAS Employee

Hi Sanjeev,

If the version of VA you are using has the stacked container you can use that to toggle between French and English. You can then use a prompt or they can switch the stack container to get the language they desire.

Regards,

Justin

Sanjeev
Fluorite | Level 6

Hi Justin,

I was hoping to solve this issue without creating a duplicate copy of the report...

In other reporting tools, I've done the following:

1) Create a custom prompt based on 2 (hard coded) values: English and French

2) Then using an expression, dynamically control which column to use. ie. if (parameter.Language = 'English')  Then Month_EN Else Month_FR

Can VA do something like this?

Sanjeev

LisaSAS
Obsidian | Level 7

I'm curious if/how this was resolved as I am needing the same thing?  I'm in version 7.3

Jatin_Jim
Obsidian | Level 7

Hello Sanjeev,

 

Just to confirm if you have one variable called language with the value of Two diff language in to your entaire dataset then please try with the global filter with drop down list which has selection of language so that the below entier report will be filterd with selected language data values..

 

Pls tell me if no need more clearity on it..........

 

 

Jim...

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1441 views
  • 0 likes
  • 4 in conversation