topic Re: Linear assets in QlikView https://community.qlik.com/t5/QlikView/Linear-assets/m-p/431759#M487723 <HTML><HEAD></HEAD><BODY><P>If I understand correctly, you should be able to apply the method Henric described in his latest blog, using a while loop:</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P></BODY></HTML> Wed, 13 Feb 2013 10:34:34 GMT swuehl 2013-02-13T10:34:34Z Linear assets https://community.qlik.com/t5/QlikView/Linear-assets/m-p/431758#M487722 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have the following type of data:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">ID</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">FROM</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">TO</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">FACT</SPAN></TH></TR><TR><TD><BR /></TD><TD>1</TD><TD>5</TD><TD>A</TD></TR><TR><TD><BR /></TD><TD>3</TD><TD>4</TD><TD>B</TD></TR><TR><TD><BR /></TD><TD>4</TD><TD>8</TD><TD>C</TD></TR><TR><TD></TD><TD>6</TD><TD>7</TD><TD>D</TD></TR><TR><TD><BR /></TD><TD>8</TD><TD>10</TD><TD>E</TD></TR></TBODY></TABLE><P></P><P>Is there an easy way to break these intervals down to the smallest possible intervals. What I want to achieve is to be able to select any interval in my dashboard: from 2 to 6 and recieve as possibilities for the fact: A + B + C.</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 13 Feb 2013 09:47:43 GMT https://community.qlik.com/t5/QlikView/Linear-assets/m-p/431758#M487722 2013-02-13T09:47:43Z Re: Linear assets https://community.qlik.com/t5/QlikView/Linear-assets/m-p/431759#M487723 <HTML><HEAD></HEAD><BODY><P>If I understand correctly, you should be able to apply the method Henric described in his latest blog, using a while loop:</P><P><A _jive_internal="true" class="loading" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates">http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates</A></P></BODY></HTML> Wed, 13 Feb 2013 10:34:34 GMT https://community.qlik.com/t5/QlikView/Linear-assets/m-p/431759#M487723 swuehl 2013-02-13T10:34:34Z