Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II

KPI selections in language change

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‌qlikviewwizardstalwar1

regards,

ramesh

9 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
qlikviewwizard
Master II
Master II

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;

Capture.PNG

ramcena306
Creator II
Creator II
Author

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

ramcena306
Creator II
Creator II
Author

Hi Kaushik, PFA,

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

No Attachment..

Kindly attach again.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
qlikviewwizard
Master II
Master II

Hi,

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

Capture.PNG

ramcena306
Creator II
Creator II
Author

hi Kaushik, please have a look at updated attachment

qlikviewwizard
Master II
Master II

Hi ramcena306 ,

You can achieve like this.

Capture.PNG

jyothish8807
Master II
Master II

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

Refer attached.

Br,

KC

Best Regards,
KC