topic Re: Line start position in Combo chart in QlikView

Line start position in Combo chart

maxsheva — Sat, 01 Apr 2017 14:21:27 GMT

Hi,

How can I change a line start position in combo?

Now I have this view

But I need this one where each new point value of line starts from the beginning of next bar.

Re: Line start position in Combo chart

sergio0592 — Sat, 01 Apr 2017 16:06:27 GMT

Not sure, it's possible.

Re: Line start position in Combo chart

vinieme12 — Sat, 01 Apr 2017 18:38:18 GMT

That line is simply connecting data points ... so if you want to start at 20 change the value of your data point for sum(Plan) for E-commerce to 20 which seems to be around 50!

but would that be correct??

Re: Line start position in Combo chart

sunny_talwar — Sat, 01 Apr 2017 20:21:01 GMT

This might be the closest you might be able to get...

Re: Line start position in Combo chart

maxsheva — Sat, 01 Apr 2017 21:36:58 GMT

Thank you for this variant. It can be used.

Let's imagine some additional 'Channel-A' with no value for this time.

When I put this '1' Bar 'Channel-A' will be shown in dimension with no value.

Re: Line start position in Combo chart

sunny_talwar — Sat, 01 Apr 2017 21:44:34 GMT

you can change the expression for 1 to be like this:

If(sum(plan) > 0 and sum(fact) > 0, 1)

I don't have access to my computer, but the idea is to force 1 to 0 when sum of fact and Sum of plan is 0

Re: Line start position in Combo chart

sunny_talwar — Sun, 02 Apr 2017 10:53:40 GMT

Image and sample attached