BookmarkSubscribeRSS Feed
Bhawna3688
Calcite | Level 5

Hi VA Users,

 

I have 2 List Control in my Report section i.e. Country and City, with an interaction defined between them. This means if I select one country in first List Control, all the cities of that country will be displayed in the second List Control. The interaction is working fine.

 

Now, I want to know if it’s possible to activate one List Control only when other List Control is selected. Example – If I select one Country in first List control, only then the City List Control should get activated. This means I should not be allowed to select the City if I did not select the Country first.

 

I hope I was able to explain the situation clearly.  Kindly revert if you know of any possible solution.

                                                                                                                    

Thanks a ton.

Bhawna

 

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

If you make the selection mandatory, one country is always selected and by that also the corresponding cities 🙂

You might also use a cross tab?!

//Fredrik

Bhawna3688
Calcite | Level 5

Thanks Fredrik for the response. What if I don't want to make the selection Mandatory. Is there a solution for this scenario?

FredrikE
Rhodochrosite | Level 12

I don't really know, maybe you can add an "-All-" - value to the dimension and create a filter that handles it :0

Maybe someone else have suggestions 🙂 ?

//Fredrik

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 3 replies
  • 815 views
  • 0 likes
  • 2 in conversation