Conditional Values displaying in List Box

[#1]

Hi All,

I have two list boxes

Type:                       Value:

Alpha                         Ana

Beta                          Sunny

                                 Mica

                                 West

If I select Type ='Alpha' then Value list box should display Ana and Sunny Only.

If I select Type = 'Beta' Then All Values in 'Value' list bos should be displayed

How to do this?

[gajapathy74]

Given below is one of the way to filter the Value list box based on Type selection. By join the Type and Value.

Type:

LOAD * INLINE [

    Type

    Alpha

    Beta

];

DataValue:

LOAD * INLINE [

    Type, Value

    Alpha, Ana

    Alpha, Sunny

    Beta, Ana

    Beta, Sunny

    Beta, Mica

    Beta, West

];

[#3]

Hi,

Pl find attached document. List box is showing all the associated values.

Instead of this I wanna to limit the values.

[Oleg_Troyansky]

What you want is the feature in the List Box properties, called "Hide Excluded". We typically recommend against it, to show people both associated and not associated values, but in certain cases it's justified to hide the values that are not associated.

[#5]

Hi,

  Go to the list box properties->General You can find the option hide excluded so you can hide the excluded values which is not associated with your selection.

[MayilVahanan · Accepted solution]

HI

PFA

Hope it helps