Multi fields in a pie chart

[wbatarfi]

My data is like the following

HospitalName	GW bed Total	GWOccupied
John Hopk	400	300
FEMC	114	0

I want to create a pie chart (Occupied and Vacant) for hospitals

the calculating of vacant = GW bed Total - GWOccupied

[javiersassen]

You can use the function ValueList to create a synthetic dimension that contains the values Occupied and Vacant:

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Syntheti...

Then for each of the two values you can use a different formula;)