Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

sachinnataraj
New Contributor II

overlap values in Pie chart

Hello Can you help me to create a pie chart where the values are repeated in two names. Is it possible to generate a pie chart where we can see these values and also may be the exact values?

For example

Total = 18979

A=9217

B=4376

C=6086

D=5942

Here I donot know which numbers are overlapping to which name.

now I am getting a pie chart like this

pie.JPG

Is it possible to get the chart with overlapping colors or something where i can show what numbers are voerlapped with what name.

Thank you in advance

Sachin

5 Replies
galax_allu
Valued Contributor

Re: overlap values in Pie chart

Are you looking for a solution like this ?

pie chart with separted values.jpgHi

sachinnataraj
New Contributor II

Re: overlap values in Pie chart

Hello,

I dont think so. I want to show the overlapping values & also visualize in pie chart something like in transparent colors.

Total = 18979

A=9217

B=4376

C=6086

D=5942

for example

AC=500 

AD=200

BC=150

BD=100

Thus i get a distinct

A,B,C,D

I hope its understandable.

sachinnataraj
New Contributor II

Re: overlap values in Pie chart

May be a venn diagram or if it is possible to show in any graphical representation in Qlik sense.

galax_allu
Valued Contributor

Re: overlap values in Pie chart

=if(Aggr(Sum(1), Field)>0,'Selected: $(=Concat(DISTINCT Field, ', '))

sachinnataraj
New Contributor II

Re: overlap values in Pie chart

I dont understand sorry.

I am using

Count(Distinct [Customer Name])

As i need to count the total customer name (total=18979) and show this number by type of customer (A,B,C,D)

Community Browser