topic Re: Range from to in QlikView https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422982#M808022 <HTML><HEAD></HEAD><BODY><P>id 1 doesn't seem to have any relation to others in your data. It is just linked to clothing.</P></BODY></HTML> Tue, 24 Oct 2017 18:07:37 GMT MK9885 2017-10-24T18:07:37Z Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422977#M808017 <HTML><HEAD></HEAD><BODY><P>Dear Community,</P><P></P><P>my data model is like</P><P></P><P>Measure table:</P><P></P><P>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; article</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hat</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dog</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cat</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lorry</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; car</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; skirt</P><P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jeans</P><P>8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; belt</P><P>9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bird</P><P>10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lion</P><P></P><P>fact table:</P><P></P><P>id min&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; id max&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; describtion</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; clothing</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; clothing</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; animals</P><P>9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; animals</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; others</P><P></P><P>i Need to connect These two tables and the difficult one is the id 7 which is not listed in my fact table, but Need to be connected as well... any ideas?</P><P></P><P></P><P>*EDIT* one more Information, that is very important --&gt; the relation between the tables is 1 to n, like one id in the measure table can</P><P>be for example clothing and animals...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422977#M808017 bmensing 2020-11-25T16:16:04Z Re: Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422978#M808018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>what is the key between these two tables ?</P></BODY></HTML> Tue, 24 Oct 2017 13:48:44 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422978#M808018 YoussefBelloum 2017-10-24T13:48:44Z Re: Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422979#M808019 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can try with:</P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P></P><P>Saludos.</P></BODY></HTML> Tue, 24 Oct 2017 13:51:15 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422979#M808019 fvelascog72 2017-10-24T13:51:15Z Re: Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422980#M808020 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG style="font-size: 10pt;">LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> * <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> id, article<BR /> 1, hat<BR /> 2, dog<BR /> 3, cat<BR /> 4, lorry<BR /> 5, car<BR /> 6, skirt<BR /> 7, jeans<BR /> 8, belt<BR /> 9, bird<BR /> 10, Lion]</SPAN>;<BR /> <BR /> facttable:<BR /> <STRONG style=": ; color: #0000ff;">LOAD</STRONG> * <SPAN style="color: #0000ff;">Inline</SPAN> <SPAN style="color: #800000;">[<BR /> id min, id max, describtion<BR /> 1, 1, clothing<BR /> 6, 8, clothing<BR /> 2, 3, animals<BR /> 9, 10, animals<BR /> 4, 5, others]</SPAN>;<BR /> <BR /> <SPAN style="color: #0000ff;">IntervalMatch</SPAN> (<SPAN style="color: #800000;">id</SPAN>) <STRONG style=": ; color: #0000ff;">LOAD</STRONG> <SPAN style="color: #800000;">[id min]</SPAN>,<SPAN style="color: #800000;">[id max]</SPAN> <SPAN style="color: #0000ff;">Resident</SPAN></SPAN><SPAN style="font-size: 10pt;"> facttable; </SPAN></P><P><SPAN style="font-size: 10pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180752_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Tue, 24 Oct 2017 13:53:31 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422980#M808020 antoniotiman 2017-10-24T13:53:31Z Re: Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422981#M808021 <HTML><HEAD></HEAD><BODY><P>that Looks good to me, but unfortunately i missed that there is an 1 to n relation like</P><P></P><P>the id 1 could also be clothing and others... </P></BODY></HTML> Tue, 24 Oct 2017 14:11:59 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422981#M808021 bmensing 2017-10-24T14:11:59Z Re: Range from to https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422982#M808022 <HTML><HEAD></HEAD><BODY><P>id 1 doesn't seem to have any relation to others in your data. It is just linked to clothing.</P></BODY></HTML> Tue, 24 Oct 2017 18:07:37 GMT https://community.qlik.com/t5/QlikView/Range-from-to/m-p/1422982#M808022 MK9885 2017-10-24T18:07:37Z