Need an expression for language selection

[Anonymous]

Hey Folks,

i need some help for a table chart expression.

Depending on the selected value from field "LangSelect" in table "TableLangSelect" I would like to show the correct language text from a table.

e.g.:

When I select "EN" I would like to see in the field "LangText1" only "Screw" and "Nail" and of course the corresponding IDNR1.

How can I achieve this in an expression?

TableData1:
        LangText1,  Lang1,  IDNR1
        'Schraube', 'DE',   12345
        'Screw',    'EN',   12345
        'Nagel',    'DE',   56789
        'Nail',     'EN',   56789

TableData2:
        LangText2,  Lang2,  IDNR2
        'Auto',     'DE',   22233
        'Car',      'EN',   22233
        'LKW',      'DE',   44455
        'Truck',    'EN',   66677



TableLangSelect:       
        LangSelect
        'DE'
        'EN'

My approach was something like this:

Aggr(Only({1<LangSelect = {$(Lang1)} >} LangText1 ), LangText1)

but unfortunately it doesn't work.

[vinieme12]

where do you want to see this? inside a textbox?

just concat(Distinct LangText1&':'&IDNR1  ,chr(10))

[Anonymous]

No, in a Tablebox, something like this:

LangText1  |     IDNR1

----------------|-------------------------

Screw         |     12345

Nail             |     56789

[vinieme12]

try below

only({<Lang2 = p(LangSelect)>}IDNR2)

with LangText2 as dimension

[vinieme12]

sample app

[Anonymous]

Hi Vineeth,

this works like a charm, but unfortunately not in QlikSense.

And I need this in QlikSense.

Do you have any ideas how to use this approach in QlikSense?

BR,

Emanuel

[vinieme12 · Accepted solution]

im sure this would work with QlikSense too

only({<Lang2 = p(LangSelect)>}IDNR2)

or

only({<Lang1 = {"$(=Getfieldselections(LangSelect))"}>}IDNR1)