topic Re: Forecast in Qlikview in QlikView

Forecast in Qlikview

Tue, 16 Dec 2014 07:54:42 GMT

Hi All,

I have a table with 86 entries, with two columns - row and quantity. I have another table with forecasted entries, this time having 96 entries in total, but same number of columns.

Is there a way to display both of them against each other in a single chart?

Here are more details -

Table1:

Row (1-86)

Quantity

Table2:

Row1 (1-96)

Quantity1

Now, I created a line chart with:

Dimensions : Row1

Expressions: Quantity, Quantity1.

Below is the graph I get - with just a yellow line. Whereas I need a graph with 2 lines.

Any help would be greatly appreciated. Thanks!

Durga.

Re: Forecast in Qlikview

Gysbert_Wassenaar — Tue, 16 Dec 2014 13:42:37 GMT

Make sure the fields with the row numbers have the same name.

Re: Forecast in Qlikview

yduval75 — Tue, 16 Dec 2014 13:48:02 GMT

Table1:

LOAD

Row (1-86) as Row

Quantity

from table1

Concatenate (Table 1)

Row1 (1-96) as Row

Quantity1 as Forecast

from table 2

In your chart, row as dimension and Sum(Quantity) and Sum(Forecast) as expressions

Re: Forecast in Qlikview

Michiel_QV_Fan — Tue, 16 Dec 2014 13:52:53 GMT

Rename both fields Row (1-86) and Row1 (1-96) to an equal name and concatenate the 2 tables.

Also rename your quantity fields to (for instance) quantity and forecast for your legend names.

Table1:

Row (1-86) as Row

Quantity

Table2:

concatenate (Table1)

Row1 (1-96) as Row

Quantity1 as Forecast

Re: Forecast in Qlikview

saumyashah90 — Tue, 16 Dec 2014 13:53:40 GMT

Hi ,

This would help you