Plot Total in Pie Chart

tracycrown — Fri, 22 Jan 2021 15:06:01 GMT

Dear Sir/Madam

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

Thank you, Tracy

Re: Plot Total in Pie Chart

Lisa_P — Sun, 24 Jan 2021 22:28:08 GMT

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.

topic Plot Total in Pie Chart in QlikView

Plot Total in Pie Chart

Re: Plot Total in Pie Chart