topic HAndling japanese data in qlikview in QlikView

HAndling japanese data in qlikview

Tue, 16 Aug 2011 05:50:19 GMT

Dear All,

I am new to qlik view.

Thus the issue might be resolved or answered in previous discussions, but I couldn't find the particular thread.

My issue is that I am making a dashboard in which I have to handle japanese data.

There are two places where I can get this data ,

>> Mysql server

>> Excel csv.

I tried to import data from both these databases using charsets , eg: UTF-8,UTF, Shift Jis etc but the data was in absurd format.

While I had made a module to import data from csv to mysql and i get the correct data.

Kindly refer to the attached file for the screen shots of data in excel and imported data in mysql,

But then after importing data in qlik view I could not get data in correct format.

If theres someone who can help me out, please guide me through the process.

Thanks in advance .

Nitin Gupta

YMSLI

HAndling japanese data in qlikview

rbecher — Tue, 16 Aug 2011 13:33:35 GMT

Hi Nitin,

how is the QlikView script code?

Maybe you can upload some data example?

- Ralf

Re: HAndling japanese data in qlikview

Wed, 17 Aug 2011 03:41:39 GMT

Dear Ralf ,

Thanks for showing interest in the discussion.

Kindly refer to the attached file japanese_data.sql.zip.

This is the script of mysql in which the data persists.

Kindly check .

Thanks and regards

Nitin Gupta

YMSLI

Re: HAndling japanese data in qlikview

rbecher — Wed, 17 Aug 2011 08:31:55 GMT

Hi Nitin,

I have made a CSV file (UTF-8) out of the SQL data and it works without any problem.

- Ralf

Re: HAndling japanese data in qlikview

Thu, 25 Aug 2011 08:45:22 GMT

Dear Ralf,

Thanks for the support.

Even when I checked it with my production server it was OK.

Might be it some some issue with operating system's language pack.

There is one more issue, Sorry to disturb you too much .

I want to have two input fields of date type and I want to set the dimensions of the chart as the months between these two dates.

Example

(From Date) vfrm_dt= 2011-Jan

(To Date) vto_dt= 2011-Aug

Dimesion should be >. 2011-Jan, 2011-Feb, 2011-Mar, 2011-Apr, 2011-May, 2011-Jun, 2011-Jul, 2011-Aug

for the required chart.

Please help me out for the same.

Re: HAndling japanese data in qlikview

rbecher — Thu, 25 Aug 2011 13:08:39 GMT

Hi,

I would suggest to open a new discussion for this.

- Ralf

Re: HAndling japanese data in qlikview

Architect — Thu, 06 Aug 2020 13:16:39 GMT

HI ralf,

is it possible to import Japanese data directly from the Oracle database using ODBC connection?
if yes, then how?