topic Not Getting correct representation of values in Pie chart . Help !! in QlikView

Not Getting correct representation of values in Pie chart . Help !!

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

Hi All ,

Not Getting correct representation of values in Pie chart .
The Product which is having worst perception still getting fair representation in Pie .

Ex- ROTOR WIND

Thanks & Regards

Shekar

techvarun — Fri, 28 Jul 2017 09:23:37 GMT

Hi,

You cannot plot a mix of positive and negative values in a Pie Chart.

Use Bar chart instead

Thanks,

Nagaraju_KCS — Fri, 28 Jul 2017 09:24:41 GMT

try this,

Dual (sum(Perception_Coefficient), Fabs(sum(Perception_Coefficient)))

If you want to show only positive values

Use this

RangeMax(sum(Perception_Coefficient),0)

Hope it helps......!!

shekhar_analyti — Fri, 28 Jul 2017 09:27:40 GMT

please attach qvw ..

techvarun — Fri, 28 Jul 2017 09:28:29 GMT

The only know solution according to me so far

Nagaraju_KCS — Fri, 28 Jul 2017 09:30:17 GMT

PFA,

passionate — Fri, 28 Jul 2017 09:53:50 GMT

Hi Shekhar,

Pie chart is visualization used to show percentage/Total contribution to overall value.

So, negative values makes no sense here.

Regards,

Pankaj