topic Re: Split line chart y-axix in QlikView

Split line chart y-axix

Thu, 16 May 2013 08:50:40 GMT

Hello,

Ive got this line chart:

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?

Re: Split line chart y-axix

kumarnatarajan — Thu, 16 May 2013 09:08:06 GMT

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

Re: Split line chart y-axix

sushil353 — Thu, 16 May 2013 09:08:17 GMT

Hi,

You can set the scale in Axes tab of chart.

you can post the sample app..

HTH

Sushil

Re: Split line chart y-axix

Thu, 16 May 2013 09:22:34 GMT

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

First expression alone:

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

Re: Split line chart y-axix

kumarnatarajan — Thu, 16 May 2013 09:37:16 GMT

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

Re: Split line chart y-axix

Thu, 16 May 2013 09:43:05 GMT

Here is some scramble data.

Can you show me ? I cant get it to work

Re: Split line chart y-axix

kumarnatarajan — Thu, 16 May 2013 10:50:42 GMT

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

Re: Split line chart y-axix

Thu, 16 May 2013 11:22:25 GMT

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?