Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

datanibbler
Esteemed Contributor

How to display this - piechart not quite right ...

Hi,

I have an app to compare turnover calculations from two rather large sets of data - our calculation vs. our customer's calculation.

I'd like to show the distribution of the total difference I can find between the two calculations as split up acc. to the different reasons.

<=> The differences are not all in the same direction, e.g. there are categories where we have more in our calculation than our customer and there are categories where our customer has more in their calculation.

=> I think I cannot use a piechart in that case, it would have to go beyond 100% and there would have to be some negative segments ...

=> How could I still show that graphically?

Thanks a lot!

Best regards,

DataNibbler

11 Replies
mov
Esteemed Contributor III

Re: How to display this - piechart not quite right ...

I think that a gauge chart is more appropriate here.

datanibbler
Esteemed Contributor

Re: How to display this - piechart not quite right ...

Hi Michael,

but a gauge_chart also works only if all the parts have the same prefix (either + or -), no?`

I'm not that proficient in visualizations as I have always tried to tailor my apps to my users and to keep them as simple as possible, using mostly combocharts, so maybe I'm missing something.

Could you be a bit more specific about how you think that could be done?

Thanks a lot!

MVP
MVP

Re: How to display this - piechart not quite right ...

I would use a stacked bar chart for this scenario. It is intuitive and effective for this type of comparison and handles positive and negative deltas.

HTH

Jonathan

mov
Esteemed Contributor III

Re: How to display this - piechart not quite right ...

Gauge is more flexible than that.  You can segments in negative and in positive areas.  Just give it a try.

tcullinane
Contributor II

Re: How to display this - piechart not quite right ...

Theres a few ways here including bar charts

Redmond Pie-Gauge Chart

He also has a 'Pie gauge' on his blog

Qlik Tips

morganaaron
Valued Contributor

Re: How to display this - piechart not quite right ...

When you say you want to attribute where the difference lies, does it matter if this is positive or negative difference? I.e., if it's difference, is it still not just as a big a problem regardless of which way it goes?

I think I'd use the fabs() numeric function to always return the positive value of the result, and I'd show it in a stacked bar as jonathan suggests.

You could always split out the chart into two, to show where the reasons where yours is greater, and the reasons where there's are?

datanibbler
Esteemed Contributor

Re: How to display this - piechart not quite right ...

Hi,

let's see. I'm in a webinar tomorrow that is m.o.l. all about visualization, I guess. Maybe I can glean some hints there.

At the moment, I have a different problem:

=> The way I am currently approaching the task of graphically displaying the split-up of the total difference is to
      split it up manually in the detail_data_table by making selections, then hard-coding those selections in a
       set_expression (that disregards user_selections of course) and trying to get the same number.

Those numbers don't quite add up, however. So there must be some possibility I have overlooked.

And yes, it does matter whether the difference is positive or negative as one colleague has to go and discuss the differences with our customer every month and it does matter whether I owe you 10.000 € or you owe me the same sum ;-)

mikecrengland
Contributor III

Re: How to display this - piechart not quite right ...

How about a simple bar chart? Something like:

bar.PNG

mike

morganaaron
Valued Contributor

Re: How to display this - piechart not quite right ...

Can't you think around that though? Like, use fabs() to give you the positive value but colour it based on the original value to show whether this is owed or whether you owe it - or like I mentioned, split this into two charts, one for what you owe, one for what's owed you? That way you're still looking at the correct ratios and splits, but you've got the added value of seeing what's on either side of the difference?

Community Browser