topic Re: Diffucult Problem in Chart Drawing for me... in QlikView

Diffucult Problem in Chart Drawing for me...

Sun, 13 Jan 2013 15:55:58 GMT

Dear Experts,

I am posting my sample files...

mywork.xlsx : excel file is a small part of Huge DataBase

test.xlsx : I copied sheet2 (first 2 line) of mywork excel file to "test" excel file to show you what I mean

test.qvw : QlikView file for test.xlsx

mywork.qvw : I need a chart in it !!!

Now, What I want to do,

I have to use mywork.xlsx file but I didnt success for lay-out like test.qvw. I cant do chart something like this... Expressions and Dimensions is to hard for me using mywork.xlsx

Also I am sending mywork.qvw file.. Can any body insert a chart like test.qvw to his file...

With My Best Regards

Re: Diffucult Problem in Chart Drawing for me...

nagaiank — Sun, 13 Jan 2013 16:22:31 GMT

Load yor sample data in the Sample work book using crosstable load and you willsolve your problem.

A sample qvw is attached for your reference

Re: Diffucult Problem in Chart Drawing for me...

Sun, 13 Jan 2013 17:09:19 GMT

Dear Krishnamoorthy,

I thank you for quick and excellent answer... It solved... But I have a Huge Data Base.. I want to learn :

What is the mean of 4 : I think it is "take product and data values" from 4th line from LOAD sentence...

Can you tell me the right please..

CrossTable(Product, Data, 4)

LOAD [Member Code],

Name,

COUNTRY,

[DATE(dd:mm:yyyy)],

FROM

mywork.xlsx

(ooxml, embedded labels, table is Sample);

Re: Diffucult Problem in Chart Drawing for me...

nagaiank — Sun, 13 Jan 2013 17:24:44 GMT

The first four columns of the Excel spreadsheet ([Member Code],Name,COUNTRY,[DATE(dd:mm:yyyy)]) are loaded as fields in the target table. For the remaing columns, the top row is loaded as the field Product and the data below these columns are loaded as the next field.

This is the standard method of loading crosstable data. You may refer the Qlikview reference manual for further details.

Re: Diffucult Problem in Chart Drawing for me...

Sun, 13 Jan 2013 18:23:29 GMT

Dear Krishnamoorthy,

I thank you for your help...

Kind Regards..