Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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);
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.
Dear Krishnamoorthy,
I thank you for your help...
Kind Regards..