topic Re: Funnel Chart Dimension Problem in QlikView

Funnel Chart Dimension Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello Friends, I am trying to create who got the more than 70 score and who got the in between 50-70 and below 50. So, here i want to calculate Percentage.

But, My funnel chart is not showing properly can any one help me please?

For 2014

>70 -- 5%

50-70 - 76%

<50 - 19%

For 2015

>70 -- 11%

50-70 - 68%

<50 - 21%

Re: Funnel Chart Dimension Problem

maniram23 — Sat, 06 Aug 2016 05:30:34 GMT

Hi,

Please check it..

Re: Funnel Chart Dimension Problem

Anil_Babu_Samineni — Sat, 06 Aug 2016 06:35:13 GMT

Mani, I am expecting Dimension. Can i know is that Measure if correct for Average??

Like this??

Re: Funnel Chart Dimension Problem

marjan_it — Sat, 06 Aug 2016 06:35:38 GMT

as you see in the sample,the problem is not your funnel chart, problem is about your dimension. check and change your dimension.

Re: Funnel Chart Dimension Problem

Anil_Babu_Samineni — Sat, 06 Aug 2016 06:43:05 GMT

Yes, In this if i select 2014 and Q1 it should be value of above diagram which are

>70 , >50 and <=70 & <50

Meantime, Can you please have a look of Associative. Because, when ever we click the 2014 That time Funnel chart should the Data of 2014 and this time while i am checking the name from list box, Those two values are not removed. I want to exclude two elements. Those are "Key Message Delivery" and "Sales Objective Delivery"

Re: Funnel Chart Dimension Problem

marjan_it — Sat, 06 Aug 2016 09:29:43 GMT

I could not understand your meaning. please explain more. but two name "Key Message Delivery" and "Sales Objective category" is not calculated in chart. because when you select from list box the chart get black color.

Re: Funnel Chart Dimension Problem

Anil_Babu_Samineni — Sat, 06 Aug 2016 10:01:16 GMT

Here, Please select 2014 Data and see the Score Values, Because the score values should be 100 below, Then the percentage is Similar to above which i mentioned before image.

Can you please help me, Meantime Can i know what is the Insight of that Diagram?