Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

'=Only({<Index = {15}>} [$(vLanguage)])' expression not make effect

hi all,

Recently i went through the demos Qlikview provided, and try to implement sth like the mutil-language functionality in demo 'Sales Compass'.

I create a qvw file in my pc, and copy the title expression to the objects in my qvw file(=Only({<Index = {15}>} [$(vLanguage)])), but it not works. Could you please help to fix the issue? thanks a lot

Attached is the data source and the qvw file I created.

Tags (2)
3 Replies
lironbaram
Honored Contributor II

Re: '=Only({<Index = {15}>} [$(vLanguage)])' expression not make effect

hi you changed the table of the translation build

look at the caption of the graph ,to look how you need to write your expression that it will show the translation

Not applicable

Re: '=Only({<Index = {15}>} [$(vLanguage)])' expression not make effect

Thanks liron,

I saw 2 different types for your expression, still not sure how it works for the 2nd one.

Could you please help to clarify? I seeing square bracket for the variable vLanguage.

1. =Only({<Index = {15}>}if(language= vLanguage,translation))

2. =Only({<Index = {16}>} [$(vLanguage)])

Not applicable

Re: '=Only({<Index = {15}>} [$(vLanguage)])' expression not make effect

Hello Michael,

Index function don't work when Index number is repeat many times as you do with the crosstable :

1.Remove crosstable from your script

2.Hard coding the list of language

It's works at my side in Japanses !!

Qlik_index_1.jpg

In french :

Qlik_index_2.jpg

See below Code :

===================

SET HidePrefix = '#';

Language:

LOAD Index,

     English,

     French,

     German,

     Dutch,

     Japanese

FROM

D:\temp\qlik test\language.xls

(biff, embedded labels, table is Sheet1$);

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

LanguageList:

LOAD * INLINE [

     #LANGUAGE

     English

     French

     German

     Dutch

     Japanese

];

===================

Data:

Qlik_language_data.jpg

Qlik_language_list_data.jpg

Community Browser