topic How to calculate a correct standard deviation when data periods are missing in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-a-correct-standard-deviation-when-data-periods/m-p/1371609#M841510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been looking for the answer to this problem but I have yet not succeeded to make it work in my own application, so I hope someone can help me out here.</P><P></P><P>I'm attaching a dummy application of what I'm trying to do. It contains items, months and its corresponding sales data.</P><P>I have put the same sales data for both items, but for Item A I am missing sales data for month 201605 and for item B I have put the sales to 0 for month 201605. </P><P></P><P>Item A gives me a standard deviation of 8.94, which is based on a sample of 11 months since sales for 201605 is missing. </P><P>Item B gives me a standard deviation of 10.30, which is based on a sample of 12 months since sales 201605 is populated with 0.</P><P></P><P>In this example, what should I do to show the same result for both Item A and Item B with the given data?</P><P></P><P>Thanks in advance!</P><P></P><P>Dan </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How to calculate a correct standard deviation when data periods are missing https://community.qlik.com/t5/QlikView/How-to-calculate-a-correct-standard-deviation-when-data-periods/m-p/1371609#M841510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been looking for the answer to this problem but I have yet not succeeded to make it work in my own application, so I hope someone can help me out here.</P><P></P><P>I'm attaching a dummy application of what I'm trying to do. It contains items, months and its corresponding sales data.</P><P>I have put the same sales data for both items, but for Item A I am missing sales data for month 201605 and for item B I have put the sales to 0 for month 201605. </P><P></P><P>Item A gives me a standard deviation of 8.94, which is based on a sample of 11 months since sales for 201605 is missing. </P><P>Item B gives me a standard deviation of 10.30, which is based on a sample of 12 months since sales 201605 is populated with 0.</P><P></P><P>In this example, what should I do to show the same result for both Item A and Item B with the given data?</P><P></P><P>Thanks in advance!</P><P></P><P>Dan </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-a-correct-standard-deviation-when-data-periods/m-p/1371609#M841510 Anonymous 2020-11-25T16:16:04Z