topic Re: Dimension values on the funnel itself in QlikView

Dimension values on the funnel itself

Anonymous — Fri, 09 Jan 2015 12:18:54 GMT

I have a funnel chart and want to display the labels on the funnel itself. I was able to do this for values but not for dimension.

For more clarity have a look at the picture.Can this be done?

tobias_klett — Fri, 09 Jan 2015 12:28:23 GMT

Hi utkarsh,

go to Expression an mark "Values on Data Points" extend the Expression like this:

dual(YourDimension, YourCurrentExpression)

Make sure the numbers tab in on Default.

Hope this helps

Tobias

christian77 — Fri, 09 Jan 2015 12:31:32 GMT

Hi, here it is

Anonymous — Fri, 09 Jan 2015 13:11:39 GMT

Hi Tobias,

It worked! but the problem is, I have a drill down in this graph and so the values should change dynamically.

Is this possible?

Anonymous — Fri, 09 Jan 2015 13:13:33 GMT

Thanks for the reply Christian,

I have a drill down in this chart so the values should change dynamically as I drill down.

tobias_klett — Fri, 09 Jan 2015 13:33:25 GMT

Hi utkarsh,

yes use $(=getcurrentfield(DrillDownGroup)) instead of the Dimension.

Tobias

Anonymous — Fri, 09 Jan 2015 13:52:05 GMT

Okay now I am getting greedy . If I want both the dimension and the value inside the funnel, how would you do that?

tobias_klett — Fri, 09 Jan 2015 13:54:56 GMT

dual($(=getcurrentfield(DrillDownGroup)) &' '& YourCurrentExpression , YourCurrentExpression)