topic Info Data on Pie Style in QlikView

Info Data on Pie Style

Thu, 17 Dec 2009 18:14:04 GMT

I'm developing an application to represent a certain segmentation data. I tried to represent it with a pie, but on selecting prospective pie I cannot show some percent values and/or info on the single piece.

The only way to do this seems to use the front view pie , which shows all values (only those related to expression linked to the given segmentation) for each piece. However, I cannot show both these values (for example by segmentation in the legend) and relative values on the pie.

Is there a way to have this view?

Thanks,

Giselda

Info Data on Pie Style

johnw — Sat, 19 Dec 2009 06:58:47 GMT

I'm not sure I understand the question, but is the attached what you're looking for?

Info Data on Pie Style

Tue, 05 Jan 2010 01:18:04 GMT

Hi John,

sorry for the late answer, but I was on vacation due to Christmas time!

Thanks for your help, but I don't think your example totally answered to my first question, that was about a prospective pie with quotes. The example is still concerning the front pie. So I meant to ask if I'm compelled to use only this kind of pie to show values on it.

However your example is very interesting for what concerns the problem of segmentation legend and percentage. Only a question: do you use two different tables to do this or place and sales are columns of the same table?

Thanks again,

Giselda

P.S: Happy New 2010!

Info Data on Pie Style

johnw — Tue, 05 Jan 2010 02:23:17 GMT


dp2000 wrote:do you use two different tables to do this or place and sales are columns of the same table?

They are both columns of the same table. You can see the table structure by doing a ctrl-T, or File -> Table Viewer. I'm still not understanding the original question, but you've marked it as answered, so if you're happy, I'm happy.

Info Data on Pie Style

jolivares — Mon, 21 Mar 2011 02:15:58 GMT

Hi, John

I was seeing this solution it's great for me But how may I put as legend both values in the side?

Thanks

Info Data on Pie Style

johnw — Mon, 21 Mar 2011 18:29:11 GMT

Not sure I understand. In the example, you want it to say somewhere that the % is percent of sales and the number is the total sales? Or were you looking for some sort of mini-chart next to the "place" labels? Something like this?

place sales% sales
a 4% 180
b 6% 250
c 11% 500

Something else?

Info Data on Pie Style

jolivares — Mon, 21 Mar 2011 18:52:03 GMT

Yes something like this, because if I mark "Show Numbers in Legend, just one value could be showed.

Info Data on Pie Style

johnw — Wed, 23 Mar 2011 18:20:19 GMT

Hmmm, I haven't thought of any good way to do it. You could just put a simple straight table next to the pie chart. Or you could just not use a pie chart. I'd probably personally just display this data as a straight table with a bar chart column. See attached for both of those approaches.

Info Data on Pie Style

jolivares — Wed, 23 Mar 2011 19:50:08 GMT

Good!

Check mine...

Info Data on Pie Style

johnw — Wed, 23 Mar 2011 20:10:13 GMT


Jolivares wrote:Good! Check mine...

Very nice. I considered a background color expression, but didn't do it. Looks like I should have. 🙂