Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

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
Anonymous
Not applicable

I think that a gauge chart is more appropriate here.

datanibbler
Champion
Champion
Author

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!

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

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

tcullinane
Creator II
Creator II

Theres a few ways here including bar charts

Redmond Pie-Gauge Chart

He also has a 'Pie gauge' on his blog

Qlik Tips

morganaaron
Specialist
Specialist

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
Champion
Champion
Author

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
Creator III
Creator III

How about a simple bar chart? Something like:

bar.PNG

mike

morganaaron
Specialist
Specialist

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?