topic Re: List Box in QlikView

List Box

Fri, 23 Aug 2013 20:40:24 GMT

My data is shown below within my dashboard. I'd like to create a list box that would only read the first letter of the data field and not show duplicates (A,A,A,B,D). In this case the list box would show my choice of (A, B and D). When clicking on A, I see all the fields that start with the letter A.

A 01-01-01

A 01-01-02

A 01-01-03

B 01-01-01

D 01-01-01

Any ideas on how I can perform this? I'm unsure if a list box is the best object to utilize.

Thanks,

Rob

Re: List Box

calvindk — Fri, 23 Aug 2013 20:42:28 GMT

One way could be creating a data island, with the optionvalues you want in your listbox, and then upon selecting have a trigger select in field.

Re: List Box

Oleg_Troyansky — Fri, 23 Aug 2013 21:07:57 GMT

You can create a list box with a calculated expression, something like Left(MyField, 1).

Oleg Troyansky