13 Replies Latest reply: Dec 12, 2017 2:57 AM by Petter Skjolden

Is it possible to take 2 fields in one pie

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

• 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];

Country,Product,Sales

India,A,104

India,B,140

Singapore,B,147

Singapore,B,139

Malaysia,A,128

Thailand,A,120

];

• 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

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

Hi,

Can you share your mock data. thanks

• 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

• 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

• 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)

• 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?

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

yes, u should go with bar chart for comparison instead of pie chart.

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

hi,

u want create count/ total count  & show in your pie chart?  then try to create calculated measure like below

Count (your measure field) / count (total measure field) // this will give u the desired output.

Thanks

Deva

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

Sure, but 2 measures can’t be taken on pie. Right?

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

If you are looking for a multi-level pie chart then Qlik Sense doesn't have that. But as luismadriz illustrated you can have two or more measures per dimension and show them as a label text or even measure text - but you can only show one of them as a pie slice (sized relative to the total).

• 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,