topic Transactions with Start/End Dates in QlikView https://community.qlik.com/t5/QlikView/Transactions-with-Start-End-Dates/m-p/1161011#M915522 <HTML><HEAD></HEAD><BODY><P>My fact table consists of transactional records that all have start &amp; end dates.</P><P>In that respect are Different to 'standard' transactions that just&nbsp; occur on a single date.</P><P></P><P>With that, I am really struggling on the best approach (or even just 'how') to mange these in QV, with regard to linking to calendar.</P><P></P><P>A normal transaction is easy, it has 1 date field linked to calendar, and filtering on any date just gives 1 result.</P><P>In my new case, filtering on a date, requires looking at each transactional record's start and end dates, and if the filtered date is in-between the two.</P><P>That would mean in effect linking the calendar to TWO fields on my fact table with 'greater than' and 'less than' expressions - is that even possible in QV ?</P><P></P><P>Any pointers on where to even start looking for a solution, would be gratefully received !</P><P></P><P>Many Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT simonb2013 2020-11-25T16:16:04Z Transactions with Start/End Dates https://community.qlik.com/t5/QlikView/Transactions-with-Start-End-Dates/m-p/1161011#M915522 <HTML><HEAD></HEAD><BODY><P>My fact table consists of transactional records that all have start &amp; end dates.</P><P>In that respect are Different to 'standard' transactions that just&nbsp; occur on a single date.</P><P></P><P>With that, I am really struggling on the best approach (or even just 'how') to mange these in QV, with regard to linking to calendar.</P><P></P><P>A normal transaction is easy, it has 1 date field linked to calendar, and filtering on any date just gives 1 result.</P><P>In my new case, filtering on a date, requires looking at each transactional record's start and end dates, and if the filtered date is in-between the two.</P><P>That would mean in effect linking the calendar to TWO fields on my fact table with 'greater than' and 'less than' expressions - is that even possible in QV ?</P><P></P><P>Any pointers on where to even start looking for a solution, would be gratefully received !</P><P></P><P>Many Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Transactions-with-Start-End-Dates/m-p/1161011#M915522 simonb2013 2020-11-25T16:16:04Z Re: Transactions with Start/End Dates https://community.qlik.com/t5/QlikView/Transactions-with-Start-End-Dates/m-p/1161012#M915523 <HTML><HEAD></HEAD><BODY><P>May be use IntervalMatch approach to link your Fact table to a master calendar</P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P></BODY></HTML> Fri, 27 May 2016 15:51:10 GMT https://community.qlik.com/t5/QlikView/Transactions-with-Start-End-Dates/m-p/1161012#M915523 sunny_talwar 2016-05-27T15:51:10Z