topic Re: Please Suggest in QlikView https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493409#M1148023 <HTML><HEAD></HEAD><BODY><P>sorry i have given the expression wrong :</P><P></P><P>the expression will be :</P><P></P><P>max(0,100 %- f)</P><P></P><P>How to write it in qlikview ?</P></BODY></HTML> Wed, 14 Aug 2013 11:50:27 GMT suvechha_b 2013-08-14T11:50:27Z Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493408#M1148022 <HTML><HEAD></HEAD><BODY><P>How to write it in qlikview?</P><P></P><P>max(100%-f)</P><P></P><P>Note:</P><P></P><P>f=e/b</P><P></P><P> I have already calculated f</P></BODY></HTML> Wed, 14 Aug 2013 11:32:37 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493408#M1148022 suvechha_b 2013-08-14T11:32:37Z Re: Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493409#M1148023 <HTML><HEAD></HEAD><BODY><P>sorry i have given the expression wrong :</P><P></P><P>the expression will be :</P><P></P><P>max(0,100 %- f)</P><P></P><P>How to write it in qlikview ?</P></BODY></HTML> Wed, 14 Aug 2013 11:50:27 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493409#M1148023 suvechha_b 2013-08-14T11:50:27Z Re: Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493410#M1148024 <HTML><HEAD></HEAD><BODY><P>I guess you need something like this</P><P>RangeMax(0, 1-f)</P><P></P><P>Can you explain your requirement if it is not?</P></BODY></HTML> Wed, 14 Aug 2013 11:58:51 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493410#M1148024 CELAMBARASAN 2013-08-14T11:58:51Z Re: Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493411#M1148025 <HTML><HEAD></HEAD><BODY><P>How to write the expression in qlikview ?</P><P></P><P>max( 0, 100 % - f )</P><P></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Note:</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">f= e/b</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I have already calculated f</P></BODY></HTML> Wed, 14 Aug 2013 12:03:52 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493411#M1148025 suvechha_b 2013-08-14T12:03:52Z Re: Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493412#M1148026 <HTML><HEAD></HEAD><BODY><P>i.e max ( 0 , -20 )</P><P></P><P>result will be 0 %</P><P></P><P></P><P>again if </P><P></P><P>max( 0, 50)</P><P></P><P>result will be 50 %</P><P></P><P></P><P>now, hw to get -20 or 50</P><P></P><P></P><P>it is calculated by ( 100 % - f)</P></BODY></HTML> Wed, 14 Aug 2013 12:05:45 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493412#M1148026 suvechha_b 2013-08-14T12:05:45Z Re: Please Suggest https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493413#M1148027 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Try with this</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">RangeMax(0, 100-f)</SPAN></P></BODY></HTML> Wed, 14 Aug 2013 13:44:58 GMT https://community.qlik.com/t5/QlikView/Please-Suggest/m-p/493413#M1148027 CELAMBARASAN 2013-08-14T13:44:58Z