To present 12 months (12 colum in DB) in line chart

[#1]

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.

[#2]

Yes, you can do this easily using CrossTable, like in the following example:

Crosstable (Month, Sales) Load * from MyData.csv;

JG

[alexandros17]

Hi,

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.

Alexandros

[#4 · Accepted solution]

hi

in your script

table:

CrossTable(Month, Value,2)

LOAD staff_no,

     year,

     jan,

     feb,

     mar

FROM

(ooxml, embedded labels, table is Sheet1);

then

take a combo chart--

dimension-     month

                    year

expression--     sum(value)

[jyothish8807]

Ya.. use crosstable concept.

make JAN,FEB,....... DEC as "attribute names" and all data as "Data Names".

Crosstable (Month, Sales) Load * from MyData.csv;

or otherwise you can do it while uploading the file easily.