topic Re: Pie chart Negation in QlikView

Pie chart Negation

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a scenario where in I have to plot a pie chart with 2 different values. One being my original expression (say for example it is 20%) and rest other categories are not having any values (0). Hence I have to show the pie chart including this 80% as one angle for all the zero values and 20% as other angle in the same pie. Is there a way I could negate my original expression and achieve the second expression? I could get this easily with a bar/mekko chart but not with the pie !

Thanks !

Arun

Re: Pie chart Negation

MarcoWedel — Tue, 31 Jan 2017 22:44:48 GMT

please post a sample application

thanks

regards

Marco

Re: Pie chart Negation

Wed, 01 Feb 2017 04:40:19 GMT

HI Macro,

I have attached a sample file for you. Please let me know if this helps.

Thanks!

Arun

Re: Pie chart Negation

Wed, 01 Feb 2017 04:44:18 GMT

A point to add to the above note, the same expressions work good for other charts like a bar or a Mekko chart. It does not work with the Pie.

Re: Pie chart Negation

Anil_Babu_Samineni — Wed, 01 Feb 2017 05:28:31 GMT

Thanks for sharing App, Now coming to your query. Is that possible to show which you expect from Pie chart. Please make sketch on paper and then share with us. So, Might very helpful to explain you

Re: Pie chart Negation

Siva_Sankar — Wed, 01 Feb 2017 05:37:40 GMT

Hi Arunkumar,

Please find the attached app. For the purpose you are looking for , Bar chart is appropirate.

However, i tried concatenating the field and created a pie. please take a look

Siva !

Re: Pie chart Negation

Anonymous — Wed, 01 Feb 2017 05:59:57 GMT

Hi Arun,

As you can show individual graph for each designation in single object using trills option.

please find the below attachment, iam nt sure it meets ur requirement.

Regards,

Murali Mohan .T

Re: Pie chart Negation

sdmech81 — Wed, 01 Feb 2017 08:16:03 GMT

HI Arun this is what u want??

Or further u want that 35 and 65 to b distributed based on designation?

If above is wt u want I ll share with u..