Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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

Vizlib Head of R&D

View solution in original post

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi Nitin,

how is the QlikView script code?

Maybe you can upload some data example?

- Ralf

Vizlib Head of R&D
Highlighted
Not applicable

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Vizlib Head of R&D

View solution in original post

Highlighted
Not applicable

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.

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

I would suggest to open a new discussion for this.

- Ralf

Vizlib Head of R&D
Highlighted
Contributor III
Contributor III

HI ralf,

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