Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

emanuel_oxi
New Contributor

Need an expression for language selection

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.

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Need an expression for language selection

im sure this would work with QlikSense too


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

or

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

6 Replies
vinieme12
Esteemed Contributor II

Re: Need an expression for language selection

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

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

emanuel_oxi
New Contributor

Re: Need an expression for language selection

No, in a Tablebox, something like this:

LangText1  |     IDNR1

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

Screw         |     12345

Nail             |     56789

vinieme12
Esteemed Contributor II

Re: Need an expression for language selection

try below

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

with LangText2 as dimension

vinieme12
Esteemed Contributor II

Re: Need an expression for language selection

sample app

emanuel_oxi
New Contributor

Re: Need an expression for language selection

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
Esteemed Contributor II

Re: Need an expression for language selection

im sure this would work with QlikSense too


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

or

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

Community Browser