topic Funnel Chart properties in QlikView

Funnel Chart properties

Tue, 26 Oct 2010 22:43:14 GMT

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??

Funnel Chart properties

danielrozental — Tue, 26 Oct 2010 23:40:05 GMT

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.

Funnel Chart properties

Wed, 27 Oct 2010 11:40:49 GMT

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,

Funnel Chart properties

Wed, 27 Oct 2010 20:32:05 GMT

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.

Funnel Chart properties

boorgura — Wed, 27 Oct 2010 22:18:06 GMT

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.

Funnel Chart properties

Fri, 29 Oct 2010 03:06:19 GMT

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.

Funnel Chart properties

boorgura — Fri, 29 Oct 2010 03:38:34 GMT

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.

Funnel Chart properties

pover — Fri, 29 Oct 2010 05:19:50 GMT

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.

Funnel Chart properties

Fri, 29 Oct 2010 15:40:54 GMT

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)

Funnel Chart properties

Fri, 29 Oct 2010 16:41:52 GMT

Is there a way to come around this.

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

Funnel Chart properties

pover — Fri, 29 Oct 2010 18:00:02 GMT

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.

Funnel Chart properties

Fri, 29 Oct 2010 20:14:56 GMT

Karl,

Keeping sum(1) as the first expression really helped.

Now, when I hover over the chart the value for each segment is being shown as sum(1)=1.

Is there a way to overcome this.

I am also attaching a qvw file for you to try out.

Thanks & Regards,

Bharath

Funnel Chart properties

Fri, 29 Oct 2010 20:16:24 GMT

And the sample data

Funnel Chart properties

pover — Fri, 29 Oct 2010 21:29:45 GMT

On the second expression, select the option in the expression tab "Text as pop-up". It doesn't appear you can hide the Value of the 1, but you can at least hide the sum(1) label by putting a space in the expression label.

Regards.

Funnel Chart properties

Fri, 29 Oct 2010 22:18:00 GMT

i have done that but when I export the values to a excel sheet you can see that '1' in the sheet.

Is there a way we can avoid that