Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Forecast in Qlikview

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.

4 Replies

Re: Forecast in Qlikview

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


talk is cheap, supply exceeds demand
yduval75
Contributor III

Re: Forecast in Qlikview

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

michielvandegoo
Valued Contributor

Re: Forecast in Qlikview

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

saumyashah90
Valued Contributor

Re: Forecast in Qlikview


Hi ,

This would help you

Community Browser