Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: HAndling japanese data in qlikview

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

5 Replies
MVP
MVP

HAndling japanese data in qlikview

Hi Nitin,

how is the QlikView script code?

Maybe you can upload some data example?

- Ralf

Not applicable

Re: HAndling japanese data in qlikview

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

MVP
MVP

Re: HAndling japanese data in qlikview

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

Not applicable

Re: HAndling japanese data in qlikview

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.

MVP
MVP

Re: HAndling japanese data in qlikview

Hi,

I would suggest to open a new discussion for this.

- Ralf

Community Browser