Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jaisaiqlik
New Contributor

Is it possible to take 2 fields in one pie

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

13 Replies
devarasu07
Honored Contributor II

Re: Is it possible to take 2 fields in one pie

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

];

Capture.JPG

jaisaiqlik
New Contributor

Re: Is it possible to take 2 fields in one pie

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
Honored Contributor II

Re: Is it possible to take 2 fields in one pie

Hi,

Can you share your mock data. thanks

jaisaiqlik
New Contributor

Re: Is it possible to take 2 fields in one pie

I have total count in one column 30000

I have orphan count in other column is 200

jaisaiqlik
New Contributor

Re: Is it possible to take 2 fields in one pie

So I have to show 200 orphan out of total 30000


I have to show this in pie

devarasu07
Honored Contributor II

Re: Is it possible to take 2 fields in one pie

Hi,

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

jaisaiqlik
New Contributor

Re: Is it possible to take 2 fields in one pie

Ya, here I have 2 measures.


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

devarasu07
Honored Contributor II

Re: Is it possible to take 2 fields in one pie

luismadriz
Valued Contributor

Re: Is it possible to take 2 fields in one pie

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,

Untitled.png