Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

more than one line in one line chart

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

12 Replies
Not applicable
Author

Click 'Add' under Chart Properties>Expressions:

Capture.JPG

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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!

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

I think your probelm is within the data model itself:

Capture.JPG