KPI selections in language change

[ramcena306]

Hi All, I need help , in my dashboard I have 4 kpis , and a text object to change language. My requirement is, if i select one kpi in one language , when I switch to another language the selections should happen in second language also. how can I achieve that??

jyothish8807‌qlikviewwizard‌stalwar1‌

regards,

ramesh

[kaushiknsolanki]

Hi,

Do you have 4 Text object to change language for all 4 KPI?

Also it would be helpful if you share some data and explain with example.

Regards,

Kaushik Solanki

[qlikviewwizard]

Hi ramesh g

You can achieve with this. Please check this app.

Example:

SET HidePrefix = '#';

Translations:

LOAD

     Index,

     Reference,

     English,

     Swedish,

     French,

     German,

     Dutch,

     Spanish,

     Italian,

     Japanese,

     [Chinese (Simplified)],

     [Chinese (Traditional)]

FROM

[..\Database\Movies Database Translations.xls]

(biff, embedded labels, table is [Movies Database$]);

LET vLanguage = '=Minstring(#Language)';

Language:

CROSSTABLE (Language, Translation) LOAD

Index,

     English,

     Swedish,

     French,

     German,

     Dutch,

     Spanish,

     Italian,

     Japanese,

     [Chinese (Simplified)],

     [Chinese (Traditional)]

RESIDENT Translations;

LanguageList:

LOAD Language as #Language

RESIDENT Language

WHERE Language > 0;

DROP TABLE Language;

[ramcena306]

hi qlikviewwizard‌ thanks for the rply, I want to achieve this in front end using actions in that language test object

[ramcena306]

Hi Kaushik, PFA,

in that, if I select one kpi, then I change the language the selection should apply .

[kaushiknsolanki]

No Attachment..

Kindly attach again.

Regards,

Kaushik Solanki

[qlikviewwizard]

Hi,

You can achieve with this files and code. Check the front-end as well.

[ramcena306]

hi Kaushik, please have a look at updated attachment

[qlikviewwizard]

Hi ramcena306 ,

You can achieve like this.

[jyothish8807]

You can use the logic suggested by Arjun and create buttons and use select in filed trigger.

Refer attached.

Br,

KC