https://community.qlik.com/t5/QlikView/Calculate-totals/m-p/1790230#M1232286 <P>e.g. count({&lt; Status -= {"Canceled"} &gt;} ID)</P> Wed, 10 Mar 2021 18:48:41 GMT Or 2021-03-10T18:48:41Z https://community.qlik.com/t5/QlikView/Calculate-totals/m-p/1790218#M1232284 <P>Hello Team</P><P>I have a requirement like : I need to calculate totals, percentage and average.</P><P>I have data like:</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Status&nbsp; &nbsp; Level 1&nbsp; &nbsp; &nbsp;Level 2</P><P>CDE345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Open&nbsp; &nbsp; &nbsp; AAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CCC</P><P>CD456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Closed&nbsp; &nbsp; &nbsp;BBB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ADE</P><P>CD789&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Open&nbsp; &nbsp; &nbsp; FER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RUG</P><P>CD12234&nbsp; &nbsp; &nbsp; Closed&nbsp; &nbsp; REW&nbsp; &nbsp; &nbsp; &nbsp;WIO</P><P>CD47849&nbsp; &nbsp; &nbsp; Canceled&nbsp; &nbsp;GUR&nbsp; &nbsp;BGR</P><P>CD4450&nbsp; &nbsp; &nbsp; &nbsp; Canceled&nbsp; UIT&nbsp; &nbsp; TIR</P><P>CD66789&nbsp; &nbsp; &nbsp;Canceled&nbsp; &nbsp;PPP&nbsp; &nbsp;PKAA</P><P>CD89044&nbsp; &nbsp; &nbsp;Open&nbsp; &nbsp; &nbsp; &nbsp;AAP&nbsp; &nbsp; &nbsp; AAK</P><P>CD$45590&nbsp; &nbsp;Closed&nbsp; &nbsp; VYAP&nbsp; &nbsp;APYV</P><P>CD4563&nbsp; &nbsp; &nbsp; &nbsp;Active</P><P>GOUT56&nbsp; &nbsp; nULL</P><P>I need to calculate count of id's&nbsp; and average but it should not involve canceled one's in KPI's how to write formula using set analysis.&nbsp;</P><P>Like wise I need to calculate percentage to show in bar chart using Level 1 as dimension. In measure I need to calculate percentage :(and count of id's/count(total id's)) something like that we need write formula.&nbsp;</P><P>*but it should not involve canceled id's. **</P><P>Please help asap. Thank you!</P> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Calculate-totals/m-p/1790218#M1232284 Pujitha 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Calculate-totals/m-p/1790230#M1232286 <P>e.g. count({&lt; Status -= {"Canceled"} &gt;} ID)</P> Wed, 10 Mar 2021 18:48:41 GMT https://community.qlik.com/t5/QlikView/Calculate-totals/m-p/1790230#M1232286 Or 2021-03-10T18:48:41Z