topic Re: funnel chart display values from different expressions in QlikView

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 13:22:20 GMT

hi, what i Need is to Show all values in every Level of the funnel. I did not use dimensions, only expressions, but i cannot Display the values there. I Need to Show two values per Level (absolut and percentage). I created four expressions.

any idea on how to do it?

thanks

felipe

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 13:26:17 GMT

Im sorry im not able to understand what you want. Do you want the same value to be displayed in each level?

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 13:28:11 GMT

So you want to show the count, and the % of the total for each "expression"?

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 13:29:50 GMT

no, you see on the right side the values? those values shall be Display for each level

I got the values of the first Level, but the "value on data Points" and "Display values" on the Expression does not work

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 13:30:10 GMT

yes, exactly that, in each level

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 15:02:07 GMT

Could you share the qvw?

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 15:07:52 GMT

If you want the percentage in the chart, go to Chart Properties -> Number, then choose number and show in %.

Then show the numbers in the legend as you do now. As far as I know, that's the only way to display both

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 15:19:29 GMT

You could create a text box that calculates the percentage of each "expression". Make the text box transparent and overlay the text box on top of your chart.

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 15:28:29 GMT

thanks, yes, that answers one question, but the main one, is how to Show all the values in the funnel per each Expression. Do you know how to do that? I have four expressions: REcipients, DBC open, DBC click and DBC voucher redemption. Each of them is a formula (which applies to any Expression or data set).

I did not set a Dimension, since i have different data sources in the funnel.

besides all this Details, i just Need to Show the values, as you can see in the Image for the 1st Expression (45,544)

using in the Expression tab, Values on data Points works only for the first Expression. The Option "Show value" in the expresion does not apply for funnel.

do you have an idea to solve this? thanks

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 15:37:51 GMT

Have you selected Values on Data Points for each expression?

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 15:38:22 GMT

I just created a funnel and was able to show the values on data points for 3 separate expressions. Are you sure you cleared all selections when you're viewing this?

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 16:12:31 GMT

yes, i selected values on data Points and cleared all selections

Robert, do you have a Dimension in your funnel?

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 16:14:44 GMT

No, just the expressions

Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 16:16:16 GMT

You must select : "Values on Data Points" for each expression in your chart. not just the first one.

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 16:29:51 GMT

mm, then is rare

Jacob, i selected "value on data Points" on all expressions

i probably Need to Change my table structures and set a dimension

Robert could you share with me your funnel Chart?

thanks

felipe

Re: Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 16:38:39 GMT

Apparently there is some sort of bug (i included a link to that discussion) that displays all values for values on data points in a funnel chart that shows cascading values, but I attached mine and you can see that you can get values for each expression. My recommendation would be to use a textbox with a transparent background.

Sorry bud

Funnel Charts- Displaying Multiple Values on chart

Re: Re: Re: funnel chart display values from different expressions

Thu, 05 Jun 2014 16:43:05 GMT

This shows the bugged solution at the top, and the bottom is the chart with the transparent text boxes

Re: funnel chart display values from different expressions

felcar2013 — Thu, 05 Jun 2014 16:51:22 GMT

HI Robert

this is how I see your funnel on my QV Version 11.2 SR5. As in my case i just see the first value point

Probably i Need to use the text box, or Change the data structure, so that i have a Dimension to Display all values

thanks

felipe

Re: funnel chart display values from different expressions

felcar2013 — Wed, 09 Jul 2014 16:01:05 GMT

it is possible to Display all Expression values on the Chart using QV 11.2 SR7 (11.20.12451)

my current Version is QV 11.2 SR5, and here it is not possible. Alternative it is possible to use text boxes or text in the presentation option