Is it possible to take 2 fields in one pie

[Vishnu]

In Qlik Sense is that possible to take 2 Fields on one pie chart ?

[devarasu07]

Hi,

by default nature pic only one dimension use, if u want u can combine them as new calculated dimension and use it

load *, Country &'|'& Product as [Country Product];

load * Inline [

Country,Product,Sales

India,A,104

India,B,140

Singapore,B,147

Singapore,B,139

Malaysia,A,128

Thailand,A,120

];

[Vishnu]

I have total count of people and out of that total I have this **** people count

So I have to show total and also out of.

Ex: 30 out of 100

I have to show 100 and 30

But both are two columns in one table

[devarasu07]

Hi,

Can you share your mock data. thanks

[Vishnu]

I have total count in one column 30000

I have orphan count in other column is 200

[Vishnu]

So I have to show 200 orphan out of total 30000

I have to show this in pie

[devarasu07]

Hi,

for your case Bar chart is best instead of pie chart (pie chart suitable when u have one measure and one dim)

[Vishnu]

Ya, here I have 2 measures.

So for 2 measures we can’t right in pie?

[devarasu07]

Hi,

check this article,

When to use what type of visualization ‒ Qlik Sense

[luismadriz]

HI,

You need to be able to combine those measure into something meaningful relative to each other.. Please see below example.

I hope this helps,