How to display field values conditionally in list box?

[Akina0929]

Hi,

    I have two list boxes both list boxes contains week field, first list box should show all weeks and second list box should show if i select Tuesday in first list box second list box should show Wednesday,Thursday,Friday,Sat.......  after selected all values

How can i achieve please help me.

Thank you,

[swuehl]

List boxes are basically objects to select field values.

Assuming we can create a list box 1 with values Monday to Sunday and a list box 2 showing the same values.

Assuming also you select Tuesday in list box 1 and this filters the second list box to values Wednesday to Sunday.

Now, given that a use might select then e.g. Thursday in the list box 2, how should this then

a) change the list box 1 selection

b) affect all other chart objects

?

Or put it in other words: what do you want to achieve with this constrcut?

[swuehl · Accepted solution]

If above is just a - maybe not well chosen - example, then you can use any calculated dimension as field expression (enter the field expression in <expression> dialog from dropdown list on list box properties general tab).

For example:

=If( YearField > 2010, YearField)

will show only years > 2010 in the list box.

[Anonymous]

For me it's not 100% clear what you want to achieve.

If you have a quite chaotic data model you could "cheat" by using aggr()-Listboxes.

TABLE1:
LOAD * INLINE [
F1
1
2
3
4
5
6
7
8
9
10
];

TABLE2:
LOAD * INLINE [
F2
2
4
6
8
10
];