Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pacoli2013
Contributor

Built a Pie in a straight table

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

15 Replies
pacoli2013
Contributor

Re: Built a Pie in a straight table

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 OptionsSmiley Frustratedparkline, Line with dots, Bars and Whiskers.

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

adamdavi3s
Honored Contributor

Re: Built a Pie in a straight table

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!

Capture.PNG

pacoli2013
Contributor

Re: Built a Pie in a straight table

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

adamdavi3s
Honored Contributor

Re: Built a Pie in a straight table

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

pacoli2013
Contributor

Re: Built a Pie in a straight table

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

adamdavi3s
Honored Contributor

Re: Built a Pie in a straight table

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

adamdavi3s
Honored Contributor

Re: Built a Pie in a straight table

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

adamdavi3s
Honored Contributor

Re: Built a Pie in a straight table

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))

pacoli2013
Contributor

Re: Built a Pie in a straight table

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

Community Browser