Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (2)
12 Replies
Not applicable

Re: more than one line in one line chart

Click 'Add' under Chart Properties>Expressions:

Capture.JPG

Not applicable

Re: more than one line in one line chart

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

Re: more than one line in one line chart

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

Re: more than one line in one line chart

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

Not applicable

Re: more than one line in one line chart

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

Re: more than one line in one line chart

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

Not applicable

Re: more than one line in one line chart

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

Re: more than one line in one line chart

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

Re: more than one line in one line chart

I think your probelm is within the data model itself:

Capture.JPG

Community Browser