Line Chart with total column

Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

How to display total value in line chart with two dimensions. In this example just treat as Month and Department as dimensions, 3 Department sum values along with toal line should be displayed in chart.

Please let me know in case you need any more information.

Regards,

Ravi,

Re: Line Chart with total column

swuehl — Fri, 09 Dec 2011 15:06:47 GMT

Ravi,

you could create a new dimension, maybe called DepartmentChart, that has new value Total linked to all Departments, together with each Department linked to itself:

INPUT:

CrossTable(Month, Data)

LOAD Department,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM

[.\Sample Line Chart.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 6)),

Remove(Row, Pos(Top, 5))

));

DepartmentChart:

LOAD 'Total' as DepartmentChart autogenerate 1;

Join (DepartmentChart) Load Distinct Department resident INPUT;

Concatenate LOAD Department, Department as DepartmentChart resident INPUT;

Then use a line chart with dimensions Month and DepartmentChart (you can change the label for that, of course) and with an expression =sum(Data)

That should be enough, please see attached.

Stefan

topic Re: Line Chart with total column in QlikView

Line Chart with total column

Re: Line Chart with total column