Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Yes, you can do this easily using CrossTable, like in the following example:
Crosstable (Month, Sales) Load * from MyData.csv;
JG
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
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)
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.