topic Re: Straight Table - show data based on date selections in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-show-data-based-on-date-selections/m-p/1158356#M377688 <HTML><HEAD></HEAD><BODY><P>I think you need to make changes to your script. You can create an IntervalMatch between your datefield and your From and To dates. Check here about IntervalMatch: <A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P></BODY></HTML> Thu, 09 Jun 2016 10:24:39 GMT sunny_talwar 2016-06-09T10:24:39Z Straight Table - show data based on date selections https://community.qlik.com/t5/QlikView/Straight-Table-show-data-based-on-date-selections/m-p/1158355#M377687 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello everyone,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have the following problem and I am glad for any help.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have a "static" data table with date frame information (FromDate - ToDate) for each entry. Based on a Date selection in a field I would like to show in a straight table the entries from the static table when one of the selected dates are between the date frame. Please check the image for a better explanation. In this example the green underlined entries should be visible in the straight table based on the selected dates (green highlighted). </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="problemExplanation.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127368_problemExplanation.png" style="height: 243px; width: 620px;" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have tried to implement this by using set analysis and aggr as an expression in the straight table but without any success.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thank you in advance for any help.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Best regards,</P><P style="font-size: 13.3333px;">Daniel</P></BODY></HTML> Thu, 09 Jun 2016 09:35:46 GMT https://community.qlik.com/t5/QlikView/Straight-Table-show-data-based-on-date-selections/m-p/1158355#M377687 daniel1990xyz 2016-06-09T09:35:46Z Re: Straight Table - show data based on date selections https://community.qlik.com/t5/QlikView/Straight-Table-show-data-based-on-date-selections/m-p/1158356#M377688 <HTML><HEAD></HEAD><BODY><P>I think you need to make changes to your script. You can create an IntervalMatch between your datefield and your From and To dates. Check here about IntervalMatch: <A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P></BODY></HTML> Thu, 09 Jun 2016 10:24:39 GMT https://community.qlik.com/t5/QlikView/Straight-Table-show-data-based-on-date-selections/m-p/1158356#M377688 sunny_talwar 2016-06-09T10:24:39Z