Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split line chart y-axix

Hello,

Ive got this line chart:

Capture.PNG

As you can see the light green is high on the line graph. And the rest is down in the buttom because they have low values.

Is it possible to split the graph?

Eg. from 0 to 1000 it would be 0 - 100 and then from 100 - it would be 1000 intervals.?

Anyone?

7 Replies
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

You can able to split the axes.

1. Go to axex Tab

2. Click your first expression to left then click second expression to right(top).

3. Then check the check the split axis.

else

You can also able to manage in scale option

sushil353
Master II
Master II

Hi,

You can set the scale in Axes tab of chart.

you can post the sample app..

HTH

Sushil

Not applicable
Author

That almost work - But if have two expression - It would make my first expression into one( Let me show by picture)

First expression alone:

Capture.PNG

When i then add the second expression, it takes the 4 charts and combine into one - like this:

Capture1.PNG

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

your first exp. contain small data points. but 2nd exp. contain large data poins. So split your axis that is good one . If you want more info share your QVW file

Not applicable
Author

Here is some scramble data.

Can you show me ? I cant get it to work

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

It is showing currectly . you added 2 dimentions and 2 expressions so result will come depends upon your dimentions based.

You want to show all values in one view. youn should use one expression

Use this Exp:

=

if(WildMatch(DimSalesPhases.Milestone,'LOST','POC','FIRST MEETING','CONTRACT'),



count({1<DimSalesStatus.OptionID=E({1<DimSalesStatus.OptionID={'0'}>}), DimSalesPhases.OptionID=E({1<DimSalesPhases.OptionID={'-1','25','1','2','3','4','5'}>})>} PotentialCustomerKey) //Fjerne Closed og Ukendt

,

count({1<DimSalesStatus.OptionID=E({1<DimSalesStatus.OptionID={'0'}>}), DimSalesPhases.OptionID=p({1<DimSalesPhases.Milestone={'LEAD'}>})>} PotentialCustomerKey) //Fjerne Closed og Ukendt

)

But value point are not crear view. See the attached file

Not applicable
Author

I dont get this?

What you have done, you cant split the axis into breakpoints? So now you got a big jump from the buttom milestones and the big milestone leadd (just like we started)?

I need two expressions otherwise i cant break it up?