Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

josephinetedesc
Not applicable

the list box to show A B C D E ect

The List box to show the alphabet and then when a letter is selected, all the items that start with that letter to be shown.

Thank you

Jo

1 Solution

Accepted Solutions
Not applicable

Re: the list box to show A B C D E ect

Instead of Changing the script and adding inline table, we can create a ListBox with an Expression

=Left(ITEM_NAME, 1). This would generate a listbox with single unique characters according to your item name.

3 Replies
Not applicable

Re: the list box to show A B C D E ect

How you are loading these letters. Are they coming from some table or file.

To resolve this you can have an Inline load at the begining of the script and that should resolve your problem.

Load * Inline [

Yourfieldname

A,

B,

C,

D,

E];

Not applicable

Re: the list box to show A B C D E ect

Instead of Changing the script and adding inline table, we can create a ListBox with an Expression

=Left(ITEM_NAME, 1). This would generate a listbox with single unique characters according to your item name.

josephinetedesc
Not applicable

Re: the list box to show A B C D E ect

THank you this was very very easy to do and exactly what I wanted!

Jo