more than one line in one line chart

[#1]

Hello,

I have data for 12 months, which I can easily show in a line chart (months 1 to 12). Now I also have a prediction for month 13 to 15 which I would like to add to the some line chart but with another colour. And then I also have 2 other lines, the confidence interval for the prediction of month 13 to 15, which I also would like to add with different colours.

How do I add additional lines to a line chart?

-Nick

[#2]

Click 'Add' under Chart Properties>Expressions:

[#3]

Well, I have to say it isn't that easy maybe. My months are strings like:

T-12    T-11    T-10 ... T-4

I have real data vom T-12 to T-7 and predictions / confidence values

from T-6 to T-4.

And the problem is, I have "T-6"; "T-5" "T-4" for my prediction and for

my confidence intervals = T-6 for prediction value and T-6 for

conficendence interval (positive) and T-6 for vonfidence interval

(negativ). The problem is that QlikView doesn't seem to handle the

string names which are double for prediction and confidence.

Maybe that helps for clarification.

Thx

-Nick

[#4]

Well, I have to say it isn't that easy maybe. My months are strings like:

T-12    T-11    T-10 ... T-4

I have real data vom T-12 to T-7 and predictions / confidence values from T-6 to T-4.

And the problem is, I have "T-6"; "T-5" "T-4" for my prediction and for my confidence intervals = T-6 for prediction value and T-6 for conficendence interval (positive) and T-6 for vonfidence interval (negativ). The problem is that QlikView doesn't seem to handle the string names which are double for prediction and confidence.

Maybe that helps for clarification.

[#5]

That's still doable. Can you upload a sample file with some fake data?

[#6]

Here is my Excel Sample file and the script file I use. Since I only have the private version of QlikView you could not save changes to my file I think.

I had to use crosstab to get the data in the right form for a line chart.

Thanks for your help!

[#7]

What dimensions/expressions are you using now? What is the end goal?

[#8]

The goal is to show a line from T36 to T7 with the values which are in the columns only for one VFC I want to select, another one (another colour) for the prediction and later 2 other lines for confidence intervals.

So every line a single line chart by selection of VFC.

[#9]

I tried to use 2 expression (Werte) but it ended in two identical line even if there are no values for the prediction outside T6 to T4.

[#10]

I think your probelm is within the data model itself: