Solved: Funnel Chart properties - Qlik Community

Report Inappropriate Content · ‎2010-10-26

Hi,

Are there any properties for the funnel chart where I can increase the number of sections for a funnel chart.

I have 17 stages and I want to see the % of entries in each stage.

But when I create funnel chart I get to see only one stage i.e., PENDING - 95% & OTHERS.

When I select OTHERS I can see the next 8 stages but the % is relative only to those stages.

I want to see all the 17 stages together.

If I create a bar chart with the same dimensions I able to get the results.

My problem is I dont understand if this is because of the data because PENDING is like 95% of the records and the Funnel chart shows it like that or if there is something wrong in the expression.

I dont think it is because of the expression because I am able to get the results with a bar chart.

Any suggestions??

pover · ‎2010-10-29

I disagree that a funnel chart is actually better at showing any type of data for good analysis. A simple table would be good in this case if the numbers have such a big difference or two bar graphs: One that shows you Pending compared to the Total and a second that shows you a break down of the other stages.

Regardless, since the size of the funnel chart section is unimportant, the first expression can be sum(1) removing the option to show the value on the data point and then keep your original expression as a second expression.

Regards.

View solution in original post

danielrozental · ‎2010-10-26

You should check the presentation tab.

You have 2 settings there that might help you

Lower Limit on Area: 0.02 by default, not sure if you can go lower than 0.01
Maximum Number of Areas: 10 by default

If you care for a recommendation I think you're better of with a bar chart anyway.

Report Inappropriate Content · ‎2010-10-27

Hi,

I think its not in the properties rather in your heirarchy, it seems that the top level of your heirarchy is Pending and Others and under Others are the other stages.

Regards,

Report Inappropriate Content · ‎2010-10-27

There is no hierarchy. The 'Others' is being generated by the Funnel Chart.

I am not able to find the setting where I can get rid of this.

boorgura · ‎2010-10-27

Can you post a sample?

The settings have to changed as lowest segment to be 0.001 (that's the least possible value)

2nd thing - looking at your data, 95% account to Pending - do you even want to show them on the graph? Else, you can easily show the rest on the chart.

Report Inappropriate Content · ‎2010-10-28

When I changed the setting to 0.001 I got 10 sections in the funnel chart.

But I want to see all the 17 stages that I have.

Changing the Maximum No. of Areas field in the properties is not fetching any results.

Is there any other option to have all the sections in one shot.

boorgura · ‎2010-10-28

Ok - here the limitation is if any chunk of data accounts to less than .1% of total, then it falls under the "Others" bucket.

The only work around for you would be not showing the Pending piece in that PIE.

so that the rest data can be easily presented.

Let me know if you have any questions.

pover · ‎2010-10-29

It might be the case that the user asked for the funnel chart, but if not, use a simpe bar chart, which is much more useful than a funnel chart. Especially when you create a funnel chart with all pieces of equal size.

It also would be better to analyze the stage without including the stage pending which is far greater than any other stage.

Regards.

Report Inappropriate Content · ‎2010-10-29

showing the %s in a bar chart is not visually good as Pending is 95% and all others are releatively very small.

And users also wants it in a funnel chart.

Showing it in a funnel chart with equal segments is much better when compared to a bar chart.

My only opton is to show all the 17 stages in a single snapshot (which I am unable to do)

Report Inappropriate Content · ‎2010-10-29

Is there a way to come around this.

I have to show Pending along with all the other stages.