topic Re: Re: Comparison in QlikView https://community.qlik.com/t5/QlikView/Comparison/m-p/526752#M1128166 <HTML><HEAD></HEAD><BODY><P><STRONG>Paul</STRONG></P><P><STRONG><BR /></STRONG></P><P>You could create a field called <SPAN style="color: #993300;"><EM>Alert</EM></SPAN> in your load script :</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P style="padding-left: 30px;"><SPAN style="font-size: 10pt; line-height: 1.5em;"><EM style="color: #993300;">If ([Actual Demand]&gt;[Monthly Coverage] ,Dual('Alert',1) , Dual('Ok',0))&nbsp;&nbsp;&nbsp;&nbsp; as Alert ,</EM></SPAN></P><P></P><P>Then simply use the Sum() function to give you the count :</P><P></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM>Sum ( [Alert] )</EM></SPAN></P><P style="padding-left: 30px;"></P><P><SPAN style="font-size: 8pt;">If you are not familiar with the Dual function, then look it up in the Help.</SPAN></P><P style="padding-left: 30px;"></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Thu, 26 Dec 2013 17:32:09 GMT Anonymous 2013-12-26T17:32:09Z Comparison https://community.qlik.com/t5/QlikView/Comparison/m-p/526749#M1128159 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>PFA,</P><P></P><P>Please anyone give some suggestions.............</P><P></P><P></P><P>Regards,</P><P>Paul</P></BODY></HTML> Thu, 26 Dec 2013 16:51:39 GMT https://community.qlik.com/t5/QlikView/Comparison/m-p/526749#M1128159 paulwalker 2013-12-26T16:51:39Z Re: Comparison https://community.qlik.com/t5/QlikView/Comparison/m-p/526750#M1128160 <HTML><HEAD></HEAD><BODY><P><STRONG>Paul</STRONG></P><P></P><P>Could you clarify what you mean by <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><EM style="color: #993300;">show count of <EM style="color: #993300; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ALERT </EM></EM></SPAN>, as I can see no field called <EM style="color: #993300; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ALERT </EM>in your data model.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; Bill</P></BODY></HTML> Thu, 26 Dec 2013 17:05:53 GMT https://community.qlik.com/t5/QlikView/Comparison/m-p/526750#M1128160 Anonymous 2013-12-26T17:05:53Z Re: Comparison https://community.qlik.com/t5/QlikView/Comparison/m-p/526751#M1128163 <HTML><HEAD></HEAD><BODY><P>Hi Bill,</P><P></P><P>Alert means already i calculated field in my STRAIGHT table</P><P>Actually i want to show alerts count.... and Comparison with MonthlyCoverage and ActualDemand</P></BODY></HTML> Thu, 26 Dec 2013 17:09:29 GMT https://community.qlik.com/t5/QlikView/Comparison/m-p/526751#M1128163 paulwalker 2013-12-26T17:09:29Z Re: Re: Comparison https://community.qlik.com/t5/QlikView/Comparison/m-p/526752#M1128166 <HTML><HEAD></HEAD><BODY><P><STRONG>Paul</STRONG></P><P><STRONG><BR /></STRONG></P><P>You could create a field called <SPAN style="color: #993300;"><EM>Alert</EM></SPAN> in your load script :</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P style="padding-left: 30px;"><SPAN style="font-size: 10pt; line-height: 1.5em;"><EM style="color: #993300;">If ([Actual Demand]&gt;[Monthly Coverage] ,Dual('Alert',1) , Dual('Ok',0))&nbsp;&nbsp;&nbsp;&nbsp; as Alert ,</EM></SPAN></P><P></P><P>Then simply use the Sum() function to give you the count :</P><P></P><P style="padding-left: 30px;"><SPAN style="color: #993300;"><EM>Sum ( [Alert] )</EM></SPAN></P><P style="padding-left: 30px;"></P><P><SPAN style="font-size: 8pt;">If you are not familiar with the Dual function, then look it up in the Help.</SPAN></P><P style="padding-left: 30px;"></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Thu, 26 Dec 2013 17:32:09 GMT https://community.qlik.com/t5/QlikView/Comparison/m-p/526752#M1128166 Anonymous 2013-12-26T17:32:09Z