Cascading Drop Down

Harsha

Hi,

In data, I have Region and States. I need to create an app, in the app I need to give three drop downs. 1. Select Region, 2. Select State and 3. Select Input File. Using Interface tools we can achieve it.

but If user select any region from under the list Select Region drop down, it has to show only the states which comes under the selected region in the select State drop down.

Ex: if user select East Region, under the select State drop down list it has to show only states comes under East, New York, New Jersey, Ohio so on.

Data:

Region	Stare	Date	Value
East	New York	01/10/2016	3487.67
East	New Jersey	01/18/2016	2376.85
Central	Texas	01/15/2016	2139.9
North	Illinois	01/22/2016	1296.18
East	Ohio	01/30/2016	2016.10

Hope there is a way to do it dynamically.

Thanks in advance,

Harsha.

patrick_digan

Perhaps a tree is what you're looking for? I've attached a simple example that has three regions and five states you list below. When you select a state, it just provides the date and value for that state that you provided in your sample. The list of states/regions is governed by the .csv file. I think this solution would answer your question ("if user select East Region, under the select State drop down list it has to show only states comes under East, New York, New Jersey, Ohio so on."), but it may not help with your final point about "Hope there is a way to do it dynamically." If you have never used the tree tool before, you could look at the sample "Tree Custom File Database" under Analytic Apps for a more robust example. Let me know if you have further questions!

Patrick

SampleTree.yxzp