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.
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.
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.