topic Re: Need an expression for language selection in App Development

Need an expression for language selection

Anonymous — Sat, 16 Nov 2024 09:42:00 GMT

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.

Re: Need an expression for language selection

vinieme12 — Fri, 02 Jun 2017 07:34:03 GMT

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

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

Re: Need an expression for language selection

Anonymous — Fri, 02 Jun 2017 08:26:25 GMT

No, in a Tablebox, something like this:

LangText1 | IDNR1

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

Screw | 12345

Nail | 56789

Re: Need an expression for language selection

vinieme12 — Fri, 02 Jun 2017 08:43:47 GMT

try below

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

with LangText2 as dimension

Re: Need an expression for language selection

vinieme12 — Fri, 02 Jun 2017 08:44:51 GMT

sample app

Re: Need an expression for language selection

Anonymous — Fri, 02 Jun 2017 12:15:57 GMT

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

Re: Need an expression for language selection

vinieme12 — Fri, 02 Jun 2017 12:33:46 GMT

im sure this would work with QlikSense too

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

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