topic Re: Translate QVD Records in QlikView

Translate QVD Records

Tue, 26 Jan 2016 17:24:17 GMT

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

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

Re: Translate QVD Records

sunny_talwar — Tue, 26 Jan 2016 17:25:45 GMT

Try this with Aggr() function:

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

Re: Translate QVD Records

Wed, 27 Jan 2016 15:15:06 GMT

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.

Re: Translate QVD Records

Wed, 27 Jan 2016 17:55:21 GMT

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