topic Re: What does following means ? in QlikView

What does following means ?

nikhilgarg — Wed, 27 Aug 2014 07:07:19 GMT

WHat does the following mean? And where this index number i.e 73 is defined??

=Minstring({<Index = {73}>} [$(vLanguage)])

Re: What does following means ?

Wed, 27 Aug 2014 08:31:05 GMT

For any QlikView document to be presented in multiple languages, all the labels for chart titles, text boxes etc. in multiple languages are stored in an external source such as Excel or CSV. A list box in the app would be used to select the language and this selection value would be stored in the variable vLanguage. With the expression "=Minstring({<Index = {73}>} [$(vLanguage)])" in chart title or text object etc. the function returns the first search result for the respective Index column value under the respective Language selected from the source table(Excel or CSV imported into QlikView).

Hope this clarifies. Please do an extensive search in the Load script dialogue of the app where this expression comes from, so you will get to know the working.

Thanks,

Sri

Re: What does following means ?

nikhilgarg — Wed, 27 Aug 2014 09:09:23 GMT

Hey,

Thanx for reply but still i did not get it exactly. WHere this index value is defined , how it is stored etc. Can you give me some example ?

Re: Re: What does following means ?

Wed, 27 Aug 2014 10:05:53 GMT

Hi Nikhil,

Please check for "Help_Desk_Management" QlikView Demo app's Load script, there is a tab called "Transalations" where an excel containing the Transalations data is loaded and transformed to make use of the expression "=Only({<Index = {3}>} [$(vLanguage)])" for labelling.

This process is used for ease of maintaining and changing the labelling of objects externally.

Hope this clarifies, please mark the post as answered if it's cleared your doubt.

Thanks,

Sri