Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

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

Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist


Hi ,

This would help you