topic Re: Built a Pie in a straight table in QlikView

Built a Pie in a straight table

pacoli2013 — Thu, 24 Nov 2016 10:10:39 GMT

Hello,

Is it possible to build a pie in a straight table ( see attachment)

I have a straight table with one Dimension (CompanyNumber) and 5 expressions:

1) Sum(BudgetAmount)

2) Sum(ActualAmount)

3) Sum(ActualAmount) - Sum(BudgetAmount)

4) if (Sum(BudgetAmount) > 0, Sum(ActualAmount) / Sum(BudgetAmount), 0)

5) If ((Sum(BudgetAmount) - Sum(ActualAmount))/ Sum(BudgetAmount)> 0, (Sum(BudgetAmount) - Sum(ActualAmount))/ Sum(BudgetAmount), 1)

If I create a Pie, I use 4 and 5 to build the two Pie-parts, so 4 + 5 is the hole pie

I had created a straight table and a trellisbox with pies for every Company one pie.

Now my Managers wants that I integrate the pies into the straight table. But I don't know how I can do that with the expressions I have,

even don't know if it is possible at all

So I could use some help

Thanks in regards

Court

Re: Built a Pie in a straight table

pacoli2013 — Thu, 24 Nov 2016 12:52:14 GMT

Extra Information:

There was such a kind of question in the past: Solution was : go to chart properties -> Select expression -> Display option -> representation -> select mini Chartdate and in Mini chart settings Select Dimension of the straight table and mode is available there.

When I do that I only have the mode Options:Sparkline, Line with dots, Bars and Whiskers.

So I think that is not the right solution, if there is a solution

Re: Built a Pie in a straight table

adamdavi3s — Thu, 24 Nov 2016 13:14:19 GMT

It might be possible, but not sure how to make the widths dynamic based on the dimension... sorry don't have more time to play but will fiddle later!

Re: Built a Pie in a straight table

pacoli2013 — Thu, 24 Nov 2016 13:25:31 GMT

Hello Adam,

Pity you have no more time to explain how you can do it, watching your Image. Hope to hear from you later

Court

Re: Built a Pie in a straight table

adamdavi3s — Thu, 24 Nov 2016 13:32:50 GMT

Hi Court,

I added the qvw for you as well.

Basically it is just a circular gauge with lots of bits turned off and the segment set to the expression

Re: Built a Pie in a straight table

pacoli2013 — Thu, 24 Nov 2016 13:44:36 GMT

Thanks Adam,

When I am logged on I don't see if a file is added to the message.

But thanks for the qvw, downloaded and will open it and learn from it.

I will try it myself,

Keep you informed

Court

Re: Built a Pie in a straight table

adamdavi3s — Thu, 24 Nov 2016 13:49:05 GMT

stalwar1‌ can you think how to adapt the segment formula to fire for each dimension rather than the object as a whole?

Re: Built a Pie in a straight table

adamdavi3s — Thu, 24 Nov 2016 13:51:14 GMT

this idea isn't the best as you can't use mini charts in a pivot either....

Re: Built a Pie in a straight table

adamdavi3s — Thu, 24 Nov 2016 13:53:17 GMT

thought this might work but it doesn't

=PICK(MATCH(dimension,'A','B','C','D','E'),Sum({<dimension={'A'}>}ActualAmount) / Sum({<dimension={'A'}>}BudgetAmount),

Sum({<dimension={'B'}>}ActualAmount) / Sum({<dimension={'B'}>}BudgetAmount),

Sum({<dimension={'C'}>}ActualAmount) / Sum({<dimension={'C'}>}BudgetAmount),

Sum({<dimension={'D'}>}ActualAmount) / Sum({<dimension={'D'}>}BudgetAmount),

Sum({<dimension={'E'}>}ActualAmount) / Sum({<dimension={'E'}>}BudgetAmount))

Re: Built a Pie in a straight table

pacoli2013 — Thu, 24 Nov 2016 16:24:52 GMT

Hello Adam,

I have build in your way of define pies in a straight table.

At the Moment Managers are happy that they have their pies.

But I'm wondering how it works because in a normal pie there are two expressions.

In the Pies I just build in, I could only see one Expression

Hope you can explain me so I can learn more and more

Thanks

Court

Re: Built a Pie in a straight table

adamdavi3s — Fri, 25 Nov 2016 08:13:56 GMT

Hi Court,

Is it working OK in your example? In mine I couldn't get the pie values to differ so each pie chart was the same.

Basically in your case because the pie will always add up to 100% you just need the one expression to tell it where the next segment should start. The first segment is 'assumed' to be 100% less your formula if that makes sense

Re: Built a Pie in a straight table

pacoli2013 — Fri, 25 Nov 2016 08:54:24 GMT

Hello Adam,

it's not working in my example:

I have limited my Dimension: only the 8 best are shown, so I have a rest.

if I have a rest of 10% or a rest of 40%, the pie looks alway the same. I think the problem is that you don't have two expressions like normal pies have.

Court

Re: Built a Pie in a straight table

Anonymous — Fri, 09 Dec 2016 11:39:51 GMT

I think it´s impossible to adjust dynamically the segment lower bound depending on the dimension (at least through Set Analysis, due to Set Analysis takes effect in a chart-level, but not in a row-level)

Did you find another way to do it or the answer is directly "not possible" 😞

Thank you,

Re: Built a Pie in a straight table

adamdavi3s — Fri, 09 Dec 2016 15:24:43 GMT

I didn't have any further time to look at this unfortunately but I suspect it isn't possible

Re: Built a Pie in a straight table

pacoli2013 — Fri, 09 Dec 2016 16:14:49 GMT

Hello Andreina,

Like Adam, I have discovered that it is not possible. a gauge turned over in a pie (like adam did) is as a small chart not possible because the expression has always the same answer.

I tried to bring in the expressions from a normal gauge /pie in to a small gauge/pie and it didn't work

Re: Built a Pie in a straight table

Anonymous — Mon, 12 Dec 2016 13:56:41 GMT

Thank you!

Andreina