List Box Grouping by alphabets

[#1]

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..!

[MK_QSL]

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 · Accepted solution]

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

[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')  )))

[#5]

Thanks Gysbert.!

Its working fine.