topic Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/501955#M1143922 <HTML><HEAD></HEAD><BODY><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;">can anyone please suggest how to write this :</P><P></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">result = max(0,100 % - f )</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">in qlikview expression</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">result must be in percentage.</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><BR /><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">please suggest the expression for "f" <BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">NB :</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">f=Sum([Error]/Sum([Actual]))</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P></BODY></HTML> Tue, 10 Sep 2013 11:25:34 GMT 2013-09-10T11:25:34Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/501955#M1143922 <HTML><HEAD></HEAD><BODY><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;">can anyone please suggest how to write this :</P><P></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">result = max(0,100 % - f )</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">in qlikview expression</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">result must be in percentage.</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><BR /><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">please suggest the expression for "f" <BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">NB :</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">f=Sum([Error]/Sum([Actual]))</SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P style="font-weight: normal; font-style: normal; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; text-align: left; text-indent: 0px;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P></BODY></HTML> Tue, 10 Sep 2013 11:25:34 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/501955#M1143922 2013-09-10T11:25:34Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/501956#M1143923 <HTML><HEAD></HEAD><BODY><P>Please follow this thread with identical question: </P><P><A _jive_internal="true" href="https://community.qlik.com/thread/91592">http://community.qlik.com/thread/91592</A></P></BODY></HTML> Tue, 10 Sep 2013 15:29:21 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/501956#M1143923 ngulliver 2013-09-10T15:29:21Z