topic Re: How to present the data as an example, interval match, i need help? in QlikView https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970300#M646063 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Marcus Thank you for your help , I could use the Interval Match functionality , however, necessary to present every day of the selected month , even if it has no record , I do not know if I could explain.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Ex.: </SPAN></P><P><SPAN lang="en"><IMG alt="qlikview1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105007_qlikview1.png" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Tue, 10 Nov 2015 15:19:43 GMT 2015-11-10T15:19:43Z How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970298#M646060 <HTML><HEAD></HEAD><BODY><P><IMG alt="qlikview.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/104974_qlikview.png" style="height: 265px; width: 620px;" /></P></BODY></HTML> Tue, 10 Nov 2015 14:26:51 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970298#M646060 2015-11-10T14:26:51Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970299#M646061 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 10 Nov 2015 14:48:25 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970299#M646061 marcus_sommer 2015-11-10T14:48:25Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970300#M646063 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Marcus Thank you for your help , I could use the Interval Match functionality , however, necessary to present every day of the selected month , even if it has no record , I do not know if I could explain.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Ex.: </SPAN></P><P><SPAN lang="en"><IMG alt="qlikview1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105007_qlikview1.png" style="height: auto;" /><BR /></SPAN></P></BODY></HTML> Tue, 10 Nov 2015 15:19:43 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970300#M646063 2015-11-10T15:19:43Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970301#M646065 <HTML><HEAD></HEAD><BODY><P>Are there missing records they must be generated, see: <A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A>. But if I look on your table all dates are existing only a few events are missing - this would is easier the you could use something like: if(len(trim(Event))=0,'No Entry', Event) as Event.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 10 Nov 2015 16:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970301#M646065 marcus_sommer 2015-11-10T16:04:07Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970302#M646069 <HTML><HEAD></HEAD><BODY><P>Hi Roberto,</P><P></P><P>Check the attachment and let me know.</P><P><IMG __jive_id="105226" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105226_Capture.PNG" style="height: auto;" /> !</P><P></P><P><SPAN style="color: #ff0000;"><STRONG>Note:</STRONG></SPAN> I just created a sample data myself (Next time provide some sample data<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" />). Adapt the date format according to your need.</P></BODY></HTML> Thu, 12 Nov 2015 04:44:43 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970302#M646069 tamilarasu 2015-11-12T04:44:43Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970303#M646070 <HTML><HEAD></HEAD><BODY><P>Hi Tamil !</P><P></P><P><SPAN lang="en">Attached is an example of my problem . What I really need is for the presentation can be presented every day of the selected month . Introducing the days they had no record 0 (zero ) as a monthly report .</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/downloadBody/13909-102-1-18151/Interval Match.qvw" title="https://community.qlik.com/servlet/JiveServlet/downloadBody/13909-102-1-18151/Interval%20Match.qvw">https://community.qlik.com/servlet/JiveServlet/downloadBody/13909-102-1-18151/Interval%20Match.qvw</A></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P></BODY></HTML> Thu, 12 Nov 2015 11:53:07 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970303#M646070 2015-11-12T11:53:07Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970304#M646071 <HTML><HEAD></HEAD><BODY><P>Hi Roberto,</P><P></P><P>I am unable to download the file. Could you post the application directly here.!!</P></BODY></HTML> Fri, 13 Nov 2015 01:39:35 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970304#M646071 tamilarasu 2015-11-13T01:39:35Z Re: How to present the data as an example, interval match, i need help? https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970305#M646072 <HTML><HEAD></HEAD><BODY><P>Hi, thanks, <SPAN lang="en">I think right now given the attachment.</SPAN></P></BODY></HTML> Fri, 13 Nov 2015 11:08:28 GMT https://community.qlik.com/t5/QlikView/How-to-present-the-data-as-an-example-interval-match-i-need-help/m-p/970305#M646072 2015-11-13T11:08:28Z