topic Significant test in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Significant-test-in-Qlikview/m-p/1405215#M817113 <HTML><HEAD></HEAD><BODY><P>I wonder how to add the significant test mark in the calculated table.</P><P>Here is an example.</P><P>The calculated chart like:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 387px;"><TBODY><TR><TD class="xl66" height="17" width="129">Overall Liking</TD><TD class="xl63" style="border-left: none;" width="129">Product 1</TD><TD class="xl63" style="border-left: none;" width="129">Product 2</TD></TR><TR><TD class="xl67" height="17">Sample Size</TD><TD class="xl64" style="border-top: none; border-left: none;">61</TD><TD class="xl64" style="border-top: none; border-left: none;">141</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">Overall Liking</TD><TD class="xl65" style="border-top: none; border-left: none;">8.1</TD><TD class="xl65" style="border-top: none; border-left: none;">6.1</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">STDEV</TD><TD class="xl65" style="border-top: none; border-left: none;">1.2</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>1.4</P><P></P></TD></TR></TBODY></TABLE><P>I want the output like:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 387px;"><TBODY><TR><TD class="xl68" height="17" width="129">Overall Liking</TD><TD class="xl65" style="border-left: none;" width="129">2091</TD><TD class="xl65" style="border-left: none;" width="129">7929</TD></TR><TR><TD class="xl71" height="17"> </TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD></TR><TR><TD class="xl69" height="17">Sample Size</TD><TD class="xl66" style="border-top: none; border-left: none;">61</TD><TD class="xl66" style="border-top: none; border-left: none;">141</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">Overall Liking</TD><TD class="xl67" style="border-top: none; border-left: none;">8.1(B)</TD><TD class="xl67" style="border-top: none; border-left: none;">6.1</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">STDEV</TD><TD class="xl67" style="border-top: none; border-left: none;">1.2</TD><TD class="xl67" style="border-top: none; border-left: none;">1.4</TD></TR></TBODY></TABLE><P></P><P>The sample size, Overall Liking, STDEV are calculated results.</P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Significant test in Qlikview https://community.qlik.com/t5/QlikView/Significant-test-in-Qlikview/m-p/1405215#M817113 <HTML><HEAD></HEAD><BODY><P>I wonder how to add the significant test mark in the calculated table.</P><P>Here is an example.</P><P>The calculated chart like:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 387px;"><TBODY><TR><TD class="xl66" height="17" width="129">Overall Liking</TD><TD class="xl63" style="border-left: none;" width="129">Product 1</TD><TD class="xl63" style="border-left: none;" width="129">Product 2</TD></TR><TR><TD class="xl67" height="17">Sample Size</TD><TD class="xl64" style="border-top: none; border-left: none;">61</TD><TD class="xl64" style="border-top: none; border-left: none;">141</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">Overall Liking</TD><TD class="xl65" style="border-top: none; border-left: none;">8.1</TD><TD class="xl65" style="border-top: none; border-left: none;">6.1</TD></TR><TR><TD class="xl67" height="17" style="border-top: none;">STDEV</TD><TD class="xl65" style="border-top: none; border-left: none;">1.2</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>1.4</P><P></P></TD></TR></TBODY></TABLE><P>I want the output like:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 387px;"><TBODY><TR><TD class="xl68" height="17" width="129">Overall Liking</TD><TD class="xl65" style="border-left: none;" width="129">2091</TD><TD class="xl65" style="border-left: none;" width="129">7929</TD></TR><TR><TD class="xl71" height="17"> </TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD></TR><TR><TD class="xl69" height="17">Sample Size</TD><TD class="xl66" style="border-top: none; border-left: none;">61</TD><TD class="xl66" style="border-top: none; border-left: none;">141</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">Overall Liking</TD><TD class="xl67" style="border-top: none; border-left: none;">8.1(B)</TD><TD class="xl67" style="border-top: none; border-left: none;">6.1</TD></TR><TR><TD class="xl69" height="17" style="border-top: none;">STDEV</TD><TD class="xl67" style="border-top: none; border-left: none;">1.2</TD><TD class="xl67" style="border-top: none; border-left: none;">1.4</TD></TR></TBODY></TABLE><P></P><P>The sample size, Overall Liking, STDEV are calculated results.</P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Significant-test-in-Qlikview/m-p/1405215#M817113 2020-11-25T16:16:04Z Re: Significant test in Qlikview https://community.qlik.com/t5/QlikView/Significant-test-in-Qlikview/m-p/1405216#M817114 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try something like</P><P></P><P><EM style="font-size: 13.3333px;">OverallLikingExpression &amp; </EM>If(<EM>OverallLikingExpression </EM>&gt;8, <SPAN style="font-size: 13.3333px;"> '(B)')</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Cheers</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Andrew</SPAN></P></BODY></HTML> Tue, 29 Aug 2017 18:16:50 GMT https://community.qlik.com/t5/QlikView/Significant-test-in-Qlikview/m-p/1405216#M817114 effinty2112 2017-08-29T18:16:50Z