HAndling japanese data in qlikview

[#1]

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

[rbecher]

Hi Nitin,

how is the QlikView script code?

Maybe you can upload some data example?

- Ralf

[#3]

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

[rbecher · Accepted solution]

Hi Nitin,

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

- Ralf

[#5]

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.

[rbecher]

Hi,

I would suggest to open a new discussion for this.

- Ralf

[Architect]

HI ralf,

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