Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List Box Grouping by alphabets

Hi All,

Is it possible to group the list box data alpghabetically.

Like there should be 3 groups A-H,I-Q and R-Z.

When user will select group A-H, only values starting with A-H should be displayed in list box.

Find the attachement for the required output.

Is it possible to implement this in QlikView??

Thanks in advance..!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can use a container object with three listboxes added to it. See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
MK_QSL
MVP
MVP

A-H

IF(Left([Payer Name],1) <='H', [Payer Name])

I-Q

=IF(Left([Payer Name],1)>='I' and Left([Customer Name],1) <= 'Q',[Payer Name])

R-Z

=IF(Left([Payer Name],1)>='R',[Payer Name])

Gysbert_Wassenaar

You can use a container object with three listboxes added to it. See attached qvw


talk is cheap, supply exceeds demand
its_anandrjs

In sort tab write

If( A-H = Match( Left([Payer Name] ,'A','B','C','D','E','F','G','H'),

If( I-Q = Match( Left([Payer Name] ,'I','J','K','L','M','N','O','P','Q'),

If( R-Z = Match( Left([Payer Name] ,'R','S','T','U','V','W','X','Y','Z')  )))

Not applicable
Author

Thanks Gysbert.!

Its working fine.