I am new in Qlikview, and hope the expert can help me. There are 12 months sales figure, store in 12 columns (please see DBFormat.jpb). I would like to present the sales figure line chart (Result.jpg - the orange line). Please help. Thanks much.
Yes, you can do this easily using CrossTable, like in the following example:
Crosstable (Month, Sales) Load * from MyData.csv;
I've prepared an example to solve your problem; the problem is linked to data format, I had to change the format.
I Hope the example may help you.
in your script
(ooxml, embedded labels, table is Sheet1);
take a combo chart--
Ya.. use crosstable concept.
make JAN,FEB,....... DEC as "attribute names" and all data as "Data Names".
or otherwise you can do it while uploading the file easily.
Retrieving data ...