topic *** IntervalMatch on String Field (Age Range) *** Please help!!! in QlikView https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311566#M115018 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Dear All,</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">I am stuck with a task. I have a dataset which is 3 million+ records and I had loaded the data from QVD. Now, I need to convert a free value Age into <STRONG>intervals/range.</STRONG> I had used intervalmatch in the past with numbers but now I need to use string values. My idea is to use the <STRONG>RecNo() </STRONG>function and generate autonumbers for each row and then using applymap function I wanted to call the numeric values of Age string Field. I am not sure if this is right appraoch but I am stuck now... I need urgent help on this one. </SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"> </SPAN><SPAN style="font-family: trebuchet ms,geneva;">I had attached the excel workbook which contains the Age String Field as sample data.</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Many thanks in advance!</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Cheers - DV<BR /></SPAN></P></BODY></HTML> Wed, 22 Jun 2011 13:47:40 GMT IAMDV 2011-06-22T13:47:40Z *** IntervalMatch on String Field (Age Range) *** Please help!!! https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311566#M115018 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Dear All,</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">I am stuck with a task. I have a dataset which is 3 million+ records and I had loaded the data from QVD. Now, I need to convert a free value Age into <STRONG>intervals/range.</STRONG> I had used intervalmatch in the past with numbers but now I need to use string values. My idea is to use the <STRONG>RecNo() </STRONG>function and generate autonumbers for each row and then using applymap function I wanted to call the numeric values of Age string Field. I am not sure if this is right appraoch but I am stuck now... I need urgent help on this one. </SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;"> </SPAN><SPAN style="font-family: trebuchet ms,geneva;">I had attached the excel workbook which contains the Age String Field as sample data.</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Many thanks in advance!</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Cheers - DV<BR /></SPAN></P></BODY></HTML> Wed, 22 Jun 2011 13:47:40 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311566#M115018 IAMDV 2011-06-22T13:47:40Z Re: *** IntervalMatch on String Field (Age Range) *** Please help!!! https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311567#M115019 <HTML><HEAD></HEAD><BODY><P><EM>DV, Check the attached application. Can some thing like this helps you?</EM></P><P></P><P><STRONG><EM>- Sridhar</EM></STRONG></P></BODY></HTML> Wed, 22 Jun 2011 14:09:01 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311567#M115019 2011-06-22T14:09:01Z Re: *** IntervalMatch on String Field (Age Range) *** Please help!!! https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311568#M115020 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Mate - This works like a charm. Good thinking! However, please can you mock up an example if the data does not have any numeric value. For example I had attached some data on ethnic groups. Please can you guide me the solution for that scenario?</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Also one more question about hierarchies. I mean if I wanted to show the Age Range from previous example and also a list of actual age number when I expand the group. What is the best way to achieve this one?</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Thanks a ton again for your help! much appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Cheers - <STRONG>DV</STRONG></SPAN></P></BODY></HTML> Wed, 22 Jun 2011 14:25:36 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311568#M115020 IAMDV 2011-06-22T14:25:36Z Re: *** IntervalMatch on String Field (Age Range) *** Please help!!! https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311569#M115021 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: trebuchet ms,geneva;">Mate - Just to update you. There are more string fields like ethnic group and I had to use intervalmatch for them to group them together. Please do let me know, what is the best appraoch to solve the issue. Also can you answer the hierarchy question as well?</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Thanks again for your time.</SPAN></P><P></P><P><SPAN style="font-family: trebuchet ms,geneva;">Cheers - DV</SPAN></P></BODY></HTML> Wed, 22 Jun 2011 14:54:06 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311569#M115021 IAMDV 2011-06-22T14:54:06Z Re: *** IntervalMatch on String Field (Age Range) *** Please help!!! https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311570#M115022 <HTML><HEAD></HEAD><BODY><P>I would think for the ethnic groups the easiest approach would be to use a mapping load &amp; applymap to identify your generic ethnicity. </P><P></P><P>ethnic_map:</P><P>Mapping load ethnicity, GenericEthnicity from Ethnic_Group.xls;</P><P></P><P>source_table:</P><P>load applymap('ethnic_map',Detailed_EthnicGroup) as Generic_Ethnicity,</P><P>*;</P><P>load * from source_data.xls;</P></BODY></HTML> Wed, 22 Jun 2011 20:22:08 GMT https://community.qlik.com/t5/QlikView/IntervalMatch-on-String-Field-Age-Range-Please-help/m-p/311570#M115022 2011-06-22T20:22:08Z