topic On the fly IntervalMatch (kind of)??? in QlikView https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241548#M461302 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Need to build an expression that do something similar to a IntervalMatch, but on the front-end.</P><P><SPAN style="font-size: 10pt;">In other words, from a table like the one </SPAN><SPAN style="font-size: 13.3333px;">below</SPAN><SPAN style="font-size: 10pt;">:</SPAN></P><P></P><P><STRONG>Grade | Rate</STRONG></P><P>&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P>&nbsp; 4,5&nbsp;&nbsp; |&nbsp; 2</P><P>&nbsp; 4,6&nbsp;&nbsp; |&nbsp; 3</P><P>&nbsp; 4,7&nbsp;&nbsp; |&nbsp; 4</P><P></P><P>So, if our grade is above 0 and less than 4,5 the rate is 1, if is above 4,5 and less than 4,6 the rate is 2, etc.</P><P></P><P>The <STRONG>grade</STRONG> metric depends on the selections, so it can not be calculated in advance.</P><P>At this point I can only assign it to the total value of the aggregation (the value of total row of the table). On the attachment you have a dummy data set to walk you through the problem.</P><P></P><P>Thanks in advance,</P></BODY></HTML> Thu, 26 Jan 2017 16:00:15 GMT 2017-01-26T16:00:15Z On the fly IntervalMatch (kind of)??? https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241548#M461302 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Need to build an expression that do something similar to a IntervalMatch, but on the front-end.</P><P><SPAN style="font-size: 10pt;">In other words, from a table like the one </SPAN><SPAN style="font-size: 13.3333px;">below</SPAN><SPAN style="font-size: 10pt;">:</SPAN></P><P></P><P><STRONG>Grade | Rate</STRONG></P><P>&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P>&nbsp; 4,5&nbsp;&nbsp; |&nbsp; 2</P><P>&nbsp; 4,6&nbsp;&nbsp; |&nbsp; 3</P><P>&nbsp; 4,7&nbsp;&nbsp; |&nbsp; 4</P><P></P><P>So, if our grade is above 0 and less than 4,5 the rate is 1, if is above 4,5 and less than 4,6 the rate is 2, etc.</P><P></P><P>The <STRONG>grade</STRONG> metric depends on the selections, so it can not be calculated in advance.</P><P>At this point I can only assign it to the total value of the aggregation (the value of total row of the table). On the attachment you have a dummy data set to walk you through the problem.</P><P></P><P>Thanks in advance,</P></BODY></HTML> Thu, 26 Jan 2017 16:00:15 GMT https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241548#M461302 2017-01-26T16:00:15Z Re: On the fly IntervalMatch (kind of)??? https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241549#M461303 <HTML><HEAD></HEAD><BODY><P>Check the attached</P></BODY></HTML> Thu, 26 Jan 2017 17:24:43 GMT https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241549#M461303 sunny_talwar 2017-01-26T17:24:43Z Re: On the fly IntervalMatch (kind of)??? https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241550#M461304 <HTML><HEAD></HEAD><BODY><P>Thank you very much!</P></BODY></HTML> Thu, 26 Jan 2017 18:43:10 GMT https://community.qlik.com/t5/QlikView/On-the-fly-IntervalMatch-kind-of/m-p/1241550#M461304 2017-01-26T18:43:10Z