topic Re: Connect two graphs (make them look like one) in QlikView

Connect two graphs (make them look like one)

Anonymous — Wed, 08 Nov 2017 08:30:45 GMT

Hi everybody,

I have the following problem:

I would like to create a graph showing my actual numbers and forecast numbers together in one chart.

So until October, my actual numbers would be in there and then forecast numbers. However, the graph should, as soon as it contains only forecast numbers change its color, so that it is recognizable that you look at the forecast there.

So I just went ahead and created 2 graphs (2 seperate formulars) in the same chart. One contains only actual numbers and the other one shows forecast numbers if there are no actual numbers for this month yet (e.g. Nov-Dec).

So far so good ... But now I have a nasty gap between the graphs ... Does anyone see a solution to 'connect' the red graph with the green one?

PS: I have only been working with QV for a few weeks

Thank you in advance!

Jan

Re: Connect two graphs (make them look like one)

Anil_Babu_Samineni — Wed, 08 Nov 2017 12:13:32 GMT

I believe, We can merge. Can you share sample to work around

Re: Connect two graphs (make them look like one)

jonathandienst — Wed, 08 Nov 2017 12:25:14 GMT

Have a look at merging the two expressions into one, like:

=RangeSum(<"actual" expression>, <"forecast" expression>)

Then use a conditional expression for the foreground colour (click the + next to the expression in the Properties | Expressions tab). Something to determine of the x-axis date is later than the last "actuals" date

=If([DateField] > Max({<Sales = {">0"}>} DateField), Red(), Green())

Adjust to your specific requirements.

Re: Connect two graphs (make them look like one)

Anonymous — Thu, 25 Jan 2018 08:22:00 GMT

Hi everybody,

Sorry for my late reply...

I managed to merge them visually. I have two functions now: 1. actual Profit/Loss until max(month_closed)

2. Forecast starting in max(month_closed)... They now look like one graph which switches its coulor when turning into forecast.

I guess that's not best practice but I'm fine with that as long as the result is working.

Cheers

Jan