
Re: One Color in my Pies
Gysbert Wassenaar Nov 20, 2016 7:41 AM (in response to Court van de Lisdonk)How many measures do you have in that pie chart?
my expressions (measure) Sum(Sales)/Sum (Targets)
That's only one: Sum(Sales)/sum(Targets)
It should be two: one for the hole (= 100% where Sales = Targets) and one Color for the Part (Sum(Sales)/Sum (Targets))
That's two, but what kind of measure Sales=Targets is I don't understand. Do you mean Sum( If(Sales=Targets, Sales,0)) perhaps?
Sum(LineAmount) is (Sum(Sales) + Sum (Targets))
And here is number three: Sum(LineAmount). How does that fit in with the others in your pie chart?
Please explain in more detail what you're trying to do. Post a small qlikview document that demonstrates the problem if you can.

Re: One Color in my Pies
Court van de Lisdonk Nov 22, 2016 10:43 AM (in response to Gysbert Wassenaar )Hello Gysbert,
The Dataset has one Amount and that is LineAmount.
Depending on the DataLevel (Actual or Targets) there is a Sum (Actual = Sales) and a Sum(Targets)
So when Sum(Sales) = Sum(Targets) my goal is reached = 100% and the whole Pie should be GREEN.
My problem was that my pie was red. I solved the problem:
I calculate one part by: Sum(ActualAmount) / Sum(TargetAmount) (Format in %)
And the rest by:
If ((Sum(TargetAmount)  Sum(ActualAmount))/ Sum(TargetAmount)> 0, (Sum(TargetAmount)  Sum(ActualAmount))/ Sum(TargetAmount), 0) (Format in %)
And it works well
Thank you for you reply
Regards Court
