https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778939#M717946 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/128999">@Amelia_96</a>&nbsp;</P><P>like ?</P><LI-CODE lang="python">=Count({&lt;status ={'1'},duration={"&lt;30"}&gt;} ID)/Count(total ID)</LI-CODE> Mon, 01 Feb 2021 13:42:31 GMT Taoufiq_Zarra 2021-02-01T13:42:31Z https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778927#M717945 <P>Hi, can i know how do i calculate this measure in straight table/pivot table but only for certain filter values?</P><P>for example, i want to count number of ID, only if the status is equal to 1, and the duration is less than 30 days. other status, i dont want to include in the count. then i want to divide the count with status=1, with overall count.</P><P>--&gt; Count(ID where status = 1 &amp; duration &lt; 30) / Count(total ID)</P><P>But i dont know how to put it in formula to calculate for expression in table. Please help me.</P><P>Thank you so much</P> Mon, 01 Feb 2021 13:22:57 GMT https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778927#M717945 Amelia_96 2021-02-01T13:22:57Z https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778939#M717946 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/128999">@Amelia_96</a>&nbsp;</P><P>like ?</P><LI-CODE lang="python">=Count({&lt;status ={'1'},duration={"&lt;30"}&gt;} ID)/Count(total ID)</LI-CODE> Mon, 01 Feb 2021 13:42:31 GMT https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778939#M717946 Taoufiq_Zarra 2021-02-01T13:42:31Z https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778948#M717947 <P>It works! thank you !!</P> Mon, 01 Feb 2021 13:52:01 GMT https://community.qlik.com/t5/QlikView/Calculate-with-filters/m-p/1778948#M717947 Amelia_96 2021-02-01T13:52:01Z