Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Diffucult Problem in Chart Drawing for me...

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

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

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

View solution in original post

4 Replies
nagaiank
Specialist III
Specialist III

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

Not applicable
Author

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)],

     A,

     B,

     C,

     D,

     E,

     F,

     G

FROM

mywork.xlsx

(ooxml, embedded labels, table is Sample);




nagaiank
Specialist III
Specialist III

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.

Not applicable
Author

Dear Krishnamoorthy,

I thank you for your help...

Kind Regards..