topic IntervalMatch and multiplication in QlikView https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285021#M105975 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table in which I have expressions whose values are calculated via IntervalMatch</P><P>for now everything is going on just fine</P><P>however there is one expression whose value after being got by intervalMatch I want to multiply it by -0.15; is there a way to do this multiplication on the fly?</P></BODY></HTML> Sat, 16 Jul 2011 05:17:31 GMT ali_hijazi 2011-07-16T05:17:31Z IntervalMatch and multiplication https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285021#M105975 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table in which I have expressions whose values are calculated via IntervalMatch</P><P>for now everything is going on just fine</P><P>however there is one expression whose value after being got by intervalMatch I want to multiply it by -0.15; is there a way to do this multiplication on the fly?</P></BODY></HTML> Sat, 16 Jul 2011 05:17:31 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285021#M105975 ali_hijazi 2011-07-16T05:17:31Z IntervalMatch and multiplication https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285022#M105976 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The result of the IntervalMatch() Load is just another table. You probably need, though, to load that resulting table again and multiply by that figure, or you can do it in the chart expression as well.</P><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Sat, 16 Jul 2011 08:09:35 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285022#M105976 Miguel_Angel_Baeyens 2011-07-16T08:09:35Z IntervalMatch and multiplication https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285023#M105977 <HTML><HEAD></HEAD><BODY><P>how can I do this in the chart expression?</P><P>I can identify the row by a value of the dimension</P><P>but how can I get to the value of the related expression?</P></BODY></HTML> Sat, 16 Jul 2011 19:49:15 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285023#M105977 ali_hijazi 2011-07-16T19:49:15Z Re: IntervalMatch and multiplication https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285024#M105978 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you are working in the same chart, just label your expression and use the expression between brackets anywher in another expression.</P><P></P><P>If you are working in a different chart, you need to write the same exact expression in both charts.</P><P></P><P> In both cases, you can multiply the field by -0.15</P><P></P><P>For example</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>Sum(Field * -.15)</P></PRE><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Sat, 16 Jul 2011 22:08:55 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-and-multiplication/m-p/285024#M105978 Miguel_Angel_Baeyens 2011-07-16T22:08:55Z