topic Re: Using intervalMatch function.While calculating % , the sum of individual distribution exceeds 100% in QlikView https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624429#M229735 <HTML><HEAD></HEAD><BODY><P>Thanks Mr. Dariusz Mielczarek. It was my mistake not checked the entry. Appreciate <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 10 Apr 2014 21:39:49 GMT 2014-04-10T21:39:49Z Using intervalMatch function.While calculating % , the sum of individual distribution exceeds 100% https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624427#M229733 <HTML><HEAD></HEAD><BODY><P>Hello I am trying to use IntervalMatch analyze the data to count the Jam. I have the Jam count as monthly average. The data is collected over a period of 5 months and average the data.</P><P></P><P> I am using IntervalMatch function to map the data, I want to know what % of devices had Jam and occurrence. </P><P><IMG alt="intervalmatch.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57007_intervalmatch.JPG.jpg" style="width: 620px; height: 253px;" /></P><P>1)My Problem is&nbsp; The total Sum of all % is exceeding 100%</P><P>2) Any other better way to map?</P><P></P><P>Thank you Appreciate your help.</P></BODY></HTML> Thu, 10 Apr 2014 15:23:48 GMT https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624427#M229733 2014-04-10T15:23:48Z Re: Using intervalMatch function.While calculating % , the sum of individual distribution exceeds 100% https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624428#M229734 <HTML><HEAD></HEAD><BODY><P>Look here:</P><P></P><TABLE><TBODY><TR><TD>0.6001,&nbsp;&nbsp;&nbsp; </TD><TD><STRONG>4.0,</STRONG>&nbsp; </TD><TD></TD><TD> 0.6-&lt;=0.8</TD></TR><TR><TD><STRONG>0.8001,&nbsp;&nbsp; </STRONG></TD><TD> 1.0,&nbsp;&nbsp; </TD><TD> 0.8-&lt;=1</TD></TR></TBODY></TABLE><P>Your ranges are not disjunctive. It may cause 100%+ problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><TABLE class="gt-baf-table"><TBODY><TR><TD></TD><TD colspan="2"></TD><TD><P class="gt-baf-translations gt-baf-cell"><SPAN class="gt-baf-back"></SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 10 Apr 2014 18:14:23 GMT https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624428#M229734 2014-04-10T18:14:23Z Re: Using intervalMatch function.While calculating % , the sum of individual distribution exceeds 100% https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624429#M229735 <HTML><HEAD></HEAD><BODY><P>Thanks Mr. Dariusz Mielczarek. It was my mistake not checked the entry. Appreciate <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 10 Apr 2014 21:39:49 GMT https://community.qlik.com/t5/QlikView/Using-intervalMatch-function-While-calculating-the-sum-of/m-p/624429#M229735 2014-04-10T21:39:49Z