topic Funnel Chart help. in App Development

Funnel Chart help.

arusanah — Mon, 27 Aug 2018 01:44:49 GMT

Hi Friends, my requirement is to create a funnel chart using Bar chart in qliksense. I followed this thread

need help in making a Bar chart that looks like funnel

but somehow it's not working. I used all three expressions but doesn't work. I don't have a license, so am not able to view the qvw file.

if anybody has qvf. please share.

3 Expressions which I am Using :

(1-(Sum(Value)/Max(Total AGGR(Sum(Value),Category))))*.5

Dual(Num(sum(Value),'#.##0,0;-#,##,0,0'),Category)

(1-(Sum(Value)/Max(Total AGGR(Sum(Value),Category))))*.5

Any help is highly appreciated.

Re: Funnel Chart help.

Lisa_P — Mon, 27 Aug 2018 05:42:57 GMT

Hi Archana,

I have managed to make the chart like a funnel, but I can't get the labelling to do what I want. See my chart below.

Here are my settings:

Expression 1 and 3: (Max(TOTAL Aggr(sum(Value), Category))-Sum(Value))/2

Expression 2: Sum(Value)

I have created a Master item for 1 and 3 and colored it Gray

Re: Funnel Chart help.

arusanah — Mon, 27 Aug 2018 12:43:25 GMT

Hi Lisa I used same expression as your's but I get one sided chart . how are you sorting your chart? Do we need to set something in sorting or in Range -> Appearance ?

Re: Funnel Chart help.

Lisa_P — Wed, 29 Aug 2018 01:39:00 GMT

Check that it is Stacked under Appearance, Presentation