Translate QVD Records

[#1]

Is possible to use the follwing function in a List Box?

=only({<LABELID={'test'}>}LABELTX)

I've some data from a table which a need to translate based on Excel files. I'm using this function very well in the columns of the tables but I can't find a way to translate the records based on my Excel.

Example:

     I've a table with the following records:

Table 1:

     Column_1         

          A                        

          B

          C

Two Buttons:

          - ENG -> Which translate the records A, B and C to english

          - FR -> Translate the records A,B and C to french

Is this possible?

Like I said I already have this function implemented to translate the column names but for the records I'm not getting

[sunny_talwar]

Try this with Aggr() function:

=Aggr(Only({<LABELID={'test'}>}LABELTX), LABELTX)

[#3]

Why Sunnt T, but I put the cod in Dimension Name?

My question is because I'm only listing the records for the Dimension A, in expressions I've 0.

Basically I've a list with the Column_1 records.

[#4]

I'm using the Aggr expression like you said in a Search Object:

=AGGR(only({<LABELID={'test'}>}LABELTX), Field1)

Is that correct? It give me 0 values