topic Re: List Box Grouping by alphabets in QlikView

List Box Grouping by alphabets

Mon, 14 Apr 2014 14:23:41 GMT

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 — Mon, 14 Apr 2014 14:30:09 GMT

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 — Mon, 14 Apr 2014 14:36:47 GMT

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

its_anandrjs — Mon, 14 Apr 2014 14:39:09 GMT

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

Tue, 15 Apr 2014 05:42:40 GMT

Thanks Gysbert.!

Its working fine.