Plot Total in Pie Chart

[tracycrown]

Dear Sir/Madam

Kindly advise how to plot just total (57.5% & 42.5%) in Pie Chart?

Thank you, Tracy

[Lisa_P · Accepted solution]

You only need to load Yes and No, Qlik can calculate the rest, so your script should be:

CrossTable(Description, Data)
LOAD Question,
// Total,
Yes,
// [% Yes],
No
// ,
// [% No]
FROM
[C:\Users\StevenLow\Dropbox\My PC (DESKTOP-N7O0V6I)\Desktop\GeBiz-Jan 22,2021\Audit Travel Vouchers\Test-1\Test-2.xls]
(biff, embedded labels, table is Sheet1$);

The dimension is Description and the measure is Sum(Data), Relative.