topic Re: SelectionBox with Different Languages in QlikView

SelectionBox with Different Languages

pacoli2013 — Mon, 06 Feb 2017 12:19:15 GMT

Hello,

My question is: How can I translated the selectionbox optiontext? IF IT IS POSSIBLE !!!!!!

I have a Qlikview Document where it is possible for users to select a language. At the moment the options are: Dutch, English, German, Danish, Polnish and Chinese. I have an excelfile DataDict with the translations, which is loaded in the script.

For the translations I use : = Only({<Index = {498}>} $(vLanguage)) .#LANGUAGE are the language-possibilities and (in this case) 498 is the line in the excelfile where the translations are.

I succeed to translated almost everything in my document. Only the selections made by users and displayed in the selectionbox is for me the big question.

F.e. If I choose DUTCH as language and 2017 as Year, everything is translated in Dutch except YEAR in the selectionbox (see jpgfile).

I can use a TextBox with the = GetCurrentSelections() Function, but there I have the same Problem and I don't have the possibilities

of a selectionbox (Status, Clear Icons, Lock Unlock etc). Using the ColumnLabels is no Option.

Looked through many Questions and Solutions here on the site , but found no answer for my question. So I hope someone can help and has the solution,

Thanks in advance

Regards Court

Re: SelectionBox with Different Languages

Vegar — Mon, 06 Feb 2017 12:39:48 GMT

I believe you will have to duplicate your fields in your datamodel, and to achieve what you are trying to do. Eg. in your calendar dimension you will have the fields [Year], [Jaar], [Roku] etc containing the same fieldvalues for year.

Instead of putting hard coded dimensions out in the application you will have to use calculated dimensions based on your translation document. Is this an absolute must have business need? It is a bit tricky and you need to change your dimension definition in all your objects.

Re: SelectionBox with Different Languages

marcus_sommer — Mon, 06 Feb 2017 13:06:40 GMT

AFAIK it's not possible with native features. Of course there are very interesting Current Selection Alternatives possible but maybe this extension is more suitable: "Better Current Selections Box" with support to hide/translate fields.

- Marcus

Re: SelectionBox with Different Languages

vinieme12 — Mon, 06 Feb 2017 13:45:43 GMT

Read this post

Better Current Selections Box to Translate & Hide Fields (QlikTip #49)

Re: SelectionBox with Different Languages

pacoli2013 — Mon, 06 Feb 2017 14:04:06 GMT

Hello,

Thanks for the Response.

I Have read the document of Stefan WALTHER.

Think that’s what I need so I tried to download the example. Couldn’t find it

On the CodePlex page the download hat no releases

(Made an Account on the CodePlex page)

Court

Re: SelectionBox with Different Languages

vinieme12 — Mon, 06 Feb 2017 14:14:27 GMT

the instructions are clear enough , if you have trouble post a sample and we can look into it

Re: SelectionBox with Different Languages

pacoli2013 — Mon, 06 Feb 2017 14:34:40 GMT

Hello

I'm have created a new document, with the INLINE LOADS, created a Variable (Set vSelectedLangKey = Only(LangKey);)

I use Qlikview 11.2 and have a normal Current Selection Box, so I have tried to download the Version mentioned in the article:

Download & Installation

Installation of the QlikView extension easy and straightforward, there is nothing special to take care of:

Download the extension
Install the extension on your local computer (doubleclick the .qar file)
Drag’n’Drop the extension within QlikView Desktop (using WebView)
Finally deploy the extension to your server (-> detailed instruction)

Re: SelectionBox with Different Languages

marcus_sommer — Mon, 06 Feb 2017 14:41:32 GMT

Try this one:

GitHub - stefanwalther/qvBetterCurrentSelectionsBox: "Better Current Selections Box" is an advanced selection box for Ql…

- Marcus