Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.
maxsheva
Contributor II

Line start position in Combo chart

Hi,

How can I change a line start position in combo?

Now I have this view

1.jpg

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

1 Solution

Accepted Solutions

Re: Line start position in Combo chart

Image and sample attached

Capture.PNG

6 Replies
sergio0592
Valued Contributor II

Re: Line start position in Combo chart

Not sure, it's possible.

vinieme12
Esteemed Contributor II

Re: Line start position in Combo chart

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

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

Capture.PNG

maxsheva
Contributor II

Re: Line start position in Combo chart

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.

1.jpg

Re: Line start position in Combo chart

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

Image and sample attached

Capture.PNG

Community Browser