https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2510317#M104877 <P>Hi&nbsp;</P><P>What is your expected output&nbsp;</P> Mon, 17 Mar 2025 15:12:25 GMT Chanty4u 2025-03-17T15:12:25Z https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2509227#M104677 <P>Dear All,&nbsp;</P> <P>I am reading data from Excel where we have below details. Is there a way to calculate Average and count based on the below mentioned logics ?&nbsp;</P> <TABLE width="941"> <TBODY> <TR> <TD width="64">ID</TD> <TD width="64">NAME</TD> <TD width="64">Salary</TD> <TD width="75">Designation</TD> <TD width="64">Q1-Rating</TD> <TD width="64">Q2-Rating</TD> <TD width="64">Q3-Rating</TD> <TD width="64">Q4-Rating</TD> <TD width="180">Yearly Average Rating</TD> <TD width="238">Count</TD> </TR> <TR> <TD>1</TD> <TD>A</TD> <TD>10000</TD> <TD>Tester</TD> <TD>Blocked</TD> <TD>Blocked</TD> <TD>5</TD> <TD>4</TD> <TD>calculate based on Q3 and Q4</TD> <TD>Count of Quarters where we have a data</TD> </TR> <TR> <TD>2</TD> <TD>B</TD> <TD>20000</TD> <TD>Developer</TD> <TD>3</TD> <TD>Blocked</TD> <TD>Blocked</TD> <TD>4</TD> <TD>Calculate based on Q1 and Q4</TD> <TD>Count of Quarters where we have a data</TD> </TR> <TR> <TD>3</TD> <TD>C</TD> <TD>15000</TD> <TD>Lead</TD> <TD>3</TD> <TD>5</TD> <TD>4</TD> <TD>4</TD> <TD>Calculate based on all quarters</TD> <TD>Count of Quarters where we have a data</TD> </TR> <TR> <TD>4</TD> <TD>D</TD> <TD>20000</TD> <TD>Manager</TD> <TD>5</TD> <TD>5</TD> <TD>Blocked</TD> <TD>Blocked</TD> <TD>Calculate based on Q1 and Q2</TD> <TD>Count of Quarters where we have a data</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 11 Mar 2025 10:37:28 GMT https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2509227#M104677 Kaushik2020 2025-03-11T10:37:28Z https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2510317#M104877 <P>Hi&nbsp;</P><P>What is your expected output&nbsp;</P> Mon, 17 Mar 2025 15:12:25 GMT https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2510317#M104877 Chanty4u 2025-03-17T15:12:25Z https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2511062#M104996 <P>thanks for your reply. Please refer the last 2 columns for the same. Feel free to revert in case anything.&nbsp;</P> Sat, 22 Mar 2025 10:05:11 GMT https://community.qlik.com/t5/App-Development/Calculate-measure-based-on-Blocked-and-Null-values/m-p/2511062#M104996 Kaushik2020 2025-03-22T10:05:11Z