4 Replies Latest reply: Dec 16, 2014 8:53 AM by Saumya Shah RSS

    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.