Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor III

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

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

4 Replies
nagaiank
Valued Contributor III

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

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

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

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
Valued Contributor III

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

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

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

Dear Krishnamoorthy,

I thank you for your help...

Kind Regards..

Community Browser