Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

List Box

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: List Box

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

Oleg Troyansky

View solution in original post

2 Replies
Highlighted
calvindk
Contributor III

Re: List Box

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.

MVP & Luminary
MVP & Luminary

Re: List Box

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

Oleg Troyansky

View solution in original post