Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator
Creator

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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
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
Creator
Author

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

ramcena306
Creator
Creator
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
qlikviewwizard
Master II
Master II

Hi,

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

Capture.PNG

ramcena306
Creator
Creator
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