topic Please resolve the problem !! in QlikView

Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 04:49:11 GMT

HEy,

I want that whenever i open my ABC.qvw then ,

a window should be visible at front that has different languages option with English selected by default. How to do that ??

Please help.

Thanx

Re: Please resolve the problem !!

ashfaq_haseeb — Mon, 20 Oct 2014 05:15:08 GMT

Hi,

have a look at attached application

Regards

ASHFAQ

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:16:23 GMT

hey ,

I cannot open your application because i am working on personal edition.

Please tell em here what to do.

Thanks

Re: Please resolve the problem !!

ashfaq_haseeb — Mon, 20 Oct 2014 05:18:23 GMT

Hi,

Go to below path

C:\Program Files\QlikView\Examples\Documents

You will find examples

Regards

ASHFAQ

Re: Please resolve the problem !!

its_anandrjs — Mon, 20 Oct 2014 05:21:02 GMT

In the Qlikview example Samples you get good example QVW for the question that you ask. Also which version of qlikview you use.

Regards,

Anand

Re: Please resolve the problem !!

Mon, 20 Oct 2014 05:22:28 GMT

You can check the example applications installed in your machine when you installed your Qlikview 11 personal edition.

go to path mentioned by Ashfaq, you can find GolfQuest.qvw

they implemented in Qlikview, the question you have asked.

Re: Please resolve the problem !!

jagan — Mon, 20 Oct 2014 05:23:36 GMT

Hi Nikhil,

You don't need license to open this file, I think it has embedded license in it. Download and try to open.

Regards,

Jagan.

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:28:32 GMT

Hey,

Can you tell me if i select German language then , how does every matter in qlikview changes to German Language ??

What i need to do for that ??

thanks

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:28:39 GMT

Hey,

Can you tell me if i select German language then , how does every matter in qlikview changes to German Language ??

What i need to do for that ??

thanks

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:28:55 GMT

Hey,

Can you tell me if i select German language then , how does every matter in qlikview changes to German Language ??

What i need to do for that ??

thanks

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:29:02 GMT

Hey,

Can you tell me if i select German language then , how does every matter in qlikview changes to German Language ??

What i need to do for that ??

thanks

Re: Please resolve the problem !!

its_anandrjs — Mon, 20 Oct 2014 05:29:06 GMT

Hi Nikhil,

In your system the folder is created named Documents when installing the Qlikview version 11.0 or new version and location is "C:\Program Files\QlikView\Examples\Documents" . If you refer the application name Movies Database.qvw you get an idea how to implement the language based application.

Regards,

Anand

Re: Please resolve the problem !!

Mon, 20 Oct 2014 05:31:16 GMT

they were implemented through variables.

please check the example. You will got an idea.

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 05:41:21 GMT

HEy ,

I check in President.qvw but what i can see in edit script option is : They just loaded following by inline method:

LOAD * INLINE [

Language

English,

Estonian,

Japanese,

Bulgarian,

Dansk

]

And then they loaded :

Translations:

LOAD [No],

English,

Estonian,

Japanese,

Bulgarian,

Dansk

FROM

[..\Database\Translation Dictionary.xls]

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

Does Translation Dictionary.xls Contains something that do the translation ?

Please tell.

Thanks

Re: Please resolve the problem !!

its_anandrjs — Mon, 20 Oct 2014 05:41:54 GMT

In your data model you have to maintain the Translation table there in your dashboard if you use list box charts and any other objects that you use you have to change its caption string only in any other languages then you have to use Minstring function like

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

Which identify the string for the German language for your selection. It is hard to explain but if you try to use the Movies Database application then you get an idea.

Regards,

Anand

Re: Please resolve the problem !!

its_anandrjs — Mon, 20 Oct 2014 05:44:26 GMT

Yes you are right it is translation table and check all objects also for that.

Re: Re: Please resolve the problem !!

jagan — Mon, 20 Oct 2014 05:46:30 GMT

Hi Nikhil,

Check the attached sample for solution, just did one small sample for you.

Hope this helps you.

Regards,

Jagan.

Re: Please resolve the problem !!

nikhilgarg — Mon, 20 Oct 2014 06:26:08 GMT

HEy,

Example is nice. But i cannot grab it as a whole.

I mean how does the mapping is being done as per language ??

Please tell

Thanks

Re: Please resolve the problem !!

Mon, 20 Oct 2014 06:38:44 GMT

Qlikview will not automatically render and translate languages. You have to have a translating table or excel file which will store translated data and then it can be shown based on language selected.

In your database you can have table having multiple records based on language_code column, which will then be used in qlikview application.

Qlikview is not a language translator, you feed data to see data.

Thanks,

Singh

Re: Please resolve the problem !!

jagan — Mon, 20 Oct 2014 06:56:06 GMT

Hi Nikhil,

Qlikview doesn't do this automatically. You see there is an inline table with language conversions, using that you can change the language dynamically.

If it not clear can you attach a small example and let us know your expected output.

Regards,

Jagan.