Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: List Box Grouping by alphabets

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


talk is cheap, supply exceeds demand
4 Replies

Re: List Box Grouping by alphabets

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])

Re: List Box Grouping by alphabets

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


talk is cheap, supply exceeds demand

Re: List Box Grouping by alphabets

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

Re: List Box Grouping by alphabets

Thanks Gysbert.!

Its working fine.

Community Browser