Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HAndling japanese data in qlikview

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

1 Solution

Accepted Solutions
rbecher
MVP
MVP

Hi Nitin,

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

- Ralf

Japanese_data.png

Astrato.io Head of R&D

View solution in original post

6 Replies
rbecher
MVP
MVP

Hi Nitin,

how is the QlikView script code?

Maybe you can upload some data example?

- Ralf

Astrato.io Head of R&D
Not applicable
Author

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
MVP
MVP

Hi Nitin,

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

- Ralf

Japanese_data.png

Astrato.io Head of R&D
Not applicable
Author

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
MVP
MVP

Hi,

I would suggest to open a new discussion for this.

- Ralf

Astrato.io Head of R&D
Architect
Partner - Creator
Partner - Creator

HI ralf,

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