topic Re: Pie Chart in QlikView

Pie Chart

israrkhan — Sun, 08 Jun 2014 07:36:51 GMT

Hi Community,

i have a pie chart, no Dimension, and 3 expressions.

when i enable "Value on data points" for all 3 expressions, chart shows me values only for first expressions,

how to show for all 3 expressions,

But when i add 1 dimension , than chart show me value on data points for all expressions...

but i don't want to add dimension...

any help,

Re: Pie Chart

MK_QSL — Sun, 08 Jun 2014 07:51:06 GMT

Can you provide little sample data?

You can use something like attached..

Re: Re: Pie Chart

israrkhan — Sun, 08 Jun 2014 08:04:41 GMT

Kindly Find the sample file.

one chart is with 1 dimension, showing values on data points correctly,

but the other without dimension, not showing...

See the file...

Re: Pie Chart

MK_QSL — Sun, 08 Jun 2014 08:10:31 GMT

Like this?

Re: Pie Chart

israrkhan — Sun, 08 Jun 2014 08:46:36 GMT

Dear Manish,

your sample solved my problem, Thanks

But why qlikview does not show for all 3 expressions....???

any idea...

Re: Pie Chart

MK_QSL — Mon, 09 Jun 2014 07:15:08 GMT

Not quite sure... but the objective of PIE Chart is to show relation between a primary dimension to expression... so you need to have at least one dimension.....

If you want to show only values, try using Bar Chart instead of Pie chart.. it will work without dimension...

Re: Pie Chart

Anonymous — Mon, 09 Jun 2014 07:38:27 GMT

you are very Right Using Bar Chart we can see all three expression values but pie chart we cannot its a chart

based limitation

Anant

Re: Pie Chart

israrkhan — Mon, 09 Jun 2014 10:02:21 GMT

Hi Manish and Anant,

Thanks for your input,

The issue is, I Have around 200 Documents Developed in Qlikview 10 SR5, and each document have 4 or 5 Pie Charts, without dimension. and All pie charts showing value on data points correctly in Qlikview 10 SR5.

But Now we updated Qlikview 10 SR5 to Qlikview 11.20 SR5, and in Qlikview 11 .20 SR5 , we are facing this problem,

the pie charts showing value only for first expression,

i can not change in around 200 documents...

Regards

Khan

Re: Pie Chart

MK_QSL — Mon, 09 Jun 2014 10:23:42 GMT

In this case, I suggest you to write to admin, may be possibility of any bugs...

Re: Pie Chart

Anonymous — Mon, 09 Jun 2014 11:03:36 GMT

Hi,

I tried a lot but it seems a version Issue , however there is a work around to any display

value at bar pie's by adding Text in chart presentation ADD text in chart then pressing

ctrl+ shift bringing the text to there respective pie but only good for 2, 3 pie chart or if there

is no solution exist to problem but in your case I can understand it will be tough doing for 200 Docs.

I do beleve some one will come out will Master solution

Good Luck

Anant

Re: Pie Chart

israrkhan — Mon, 09 Jun 2014 11:09:26 GMT

Thanks Anant,

And Yes i know the "Text in Chart Option" or i can do it By using ValueList() function, suggested by Manish.

But 200 documents and each have 4, 5 Pie Charts, very tough job.. need to spend a week or two... 🙂

finally will contact to QlikTech..

let see what they suggest.

Thank Again for Your Help....

Khan

Re: Pie Chart

Anonymous — Wed, 17 Dec 2014 19:54:59 GMT

Hello,

are there any news about this issue?

I would like to explain what happened to me.

I developed an application with QV 11 SR1: I created many pie charts without dimension and with some expressions (with option "Value in data point").

Some of these expressions were percentage: my application wasn't able to display % symbol, even if I set the correct option in Number tab..

Furthermore, others developers with QV 11 SR2 were able to display % but pie charts display every value duplicated many times...

Is this another bug?