topic Re: overlap values in Pie chart in Connectivity & Data Prep

overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 15:27:35 GMT

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

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

Re: overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 15:52:27 GMT

Are you looking for a solution like this ?

Re: overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 15:58:51 GMT

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.

Re: overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 16:05:08 GMT

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

Re: overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 16:17:08 GMT

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

Re: overlap values in Pie chart

Anonymous — Tue, 02 Jan 2018 16:22:01 GMT

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)