Select "ALL" in List box

[Anonymous]

Friends,

I have 2 columns Name and Mark.

Name	Mark
AAA	56
bbb	26
ccc	45

I have 2 list box and 1 table box.

I need to have ALL in Name column , when i select ALL it should display all the names and mark in Table box.

How can i achieve this in List box?

Please help me out.

[its_anandrjs]

ALL is aggregate function you ca use for Mark field like

SUM(ALL Mark)

Note:- SUM(ALL Mark) will give you all sum 127.

[MK_QSL]

Another approach to select all

UPDATE : Right Click on list box and select all...

[tresesco · Accepted solution]

May be like attched sample:

[Anonymous]

How can i bring "ALL " to first row.

[tresesco]

Sort tab->Expression: =Match(Name2, 'ALL', 'AAA', 'bbb', 'ccc')

Update: If you want the same even when selection is there, try: =Match(Only({1}Name2), 'ALL', 'AAA', 'bbb', 'ccc')

[Anonymous]

If i have n number of data in Name column , how can i use this?

[Anonymous]

Its working when i select,

Tab -> Sort -> Expression - Descending and

=Match (Name2,'ALL')

It will work even if we have n number of values in Name2 Column. Without giving each data in match function.

Thanks for all your help!!!

[its_anandrjs]

Load a new table above the main table then you are able to get this see Eg

LOAD RowNo() as Rcid,Name,Mark;

LOAD * Inline

[

Name,Mark

ALL

];

Tab1:

LOAD RowNo() as Rcid,Name,Mark;

Load * Inline [

Name, Mark

AAA, 56

bbb, 26

ccc, 45

];

Hope this helps

[its_anandrjs]

If in sort you use expression Rcid then your data arrange according to the rowno sequence see my example above.