topic How to display field values conditionally in list box? in QlikView

How to display field values conditionally in list box?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to display field values conditionally in list box?

swuehl — Sat, 04 Feb 2017 09:47:31 GMT

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?

Re: How to display field values conditionally in list box?

swuehl — Sat, 04 Feb 2017 09:50:35 GMT

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.

Re: How to display field values conditionally in list box?

Anonymous — Sat, 04 Feb 2017 10:10:33 GMT

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
];