Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Performance issues with translated column labels in straight tables

Hello everybody,

I am currently developing a multilingual dashboard and am experiencing performance issues when displaying straight tables.

I implemented the translations as an island table with one column per language, so each table row carries a label like this:

=Only({<TextKey={84}>} [$(sLanguage)])

To pin down the cause of the slow refresh of my tables, I created two versions of a table which were identical except for the labels which were multilingual in the first case and simple text in the second case. I put both into a container and manually measured the average time it took for the redraw of the table to complete after I clicked the table's tab in the container.

Based on these experiments, it seems that about 50% of the total table redraw time (0.7 seconds for the table without translations, 1.4 for the translated one) are caused by the translated labels.

I also tried another translation approach by concatenating all my translation table entries into a variable and picking the right translated statement like this:

=Pick(3, $(sTranslationList))

However, this approach was only faster than the first one for a small number of translated items (<70).

Has anyone else had similar problems and suggestions on how to include the translations in a way that doesn't have such a huge impact on performance?

Community Browser