topic Interval in expression in QlikView https://community.qlik.com/t5/QlikView/Interval-in-expression/m-p/635559#M233100 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Does anyone know if I can in table expression to check whether some percentage value less then other in some field?</P><P></P><P>I have table with field Year,Minimal Realization % and Bonus Amount (LCY),(picture below), what I want is to check all values from field minimal realization and gave him bonus amount if calculated value is less than values in minimal realization.</P><P></P><P>If my calculated vlaue is 93%, I want to gave him 10.000,00 bonus</P><P></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59942_1.png" /></P><P></P><P>Hope someone can help me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 02 Jun 2014 12:44:32 GMT 2014-06-02T12:44:32Z Interval in expression https://community.qlik.com/t5/QlikView/Interval-in-expression/m-p/635559#M233100 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Does anyone know if I can in table expression to check whether some percentage value less then other in some field?</P><P></P><P>I have table with field Year,Minimal Realization % and Bonus Amount (LCY),(picture below), what I want is to check all values from field minimal realization and gave him bonus amount if calculated value is less than values in minimal realization.</P><P></P><P>If my calculated vlaue is 93%, I want to gave him 10.000,00 bonus</P><P></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59942_1.png" /></P><P></P><P>Hope someone can help me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 02 Jun 2014 12:44:32 GMT https://community.qlik.com/t5/QlikView/Interval-in-expression/m-p/635559#M233100 2014-06-02T12:44:32Z Re: Interval in expression https://community.qlik.com/t5/QlikView/Interval-in-expression/m-p/635560#M233101 <HTML><HEAD></HEAD><BODY><P>Could you share your qvw so we can help you better?</P></BODY></HTML> Mon, 02 Jun 2014 12:50:17 GMT https://community.qlik.com/t5/QlikView/Interval-in-expression/m-p/635560#M233101 2014-06-02T12:50:17Z