https://community.qlik.com/t5/App-Development/Two-fields-with-time-values-new-time-related-insight/m-p/1687306#M52361 <P>I've got a CSV table with the following structure (represent inspections), loaded as a table in Qlik (dd-mm-yyyy):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 212px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30514iAC0F1A6A52F324FB/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>At an given moment, an inspection is:</P><P>- "Not started" when the given moment is before the "started" date</P><P>- "Open" when the inspection is started before the given moment but is not finished before the given moment</P><P>- "Finished" when the inspection is finished before the given moment.</P><P>&nbsp;</P><P>I'd like to create an insight that weekly (let's say every beginning of a week, started at 01-01-2020) shows how many inspections are "Open", as simple as possible, to see progression. Is it possible to create this insight without creating a new table in Qlik?&nbsp;<BR />- If it is: How could I do this?</P><P>- If not: How could I do this the easiest?</P> Tue, 24 Mar 2020 13:04:15 GMT sandervw 2020-03-24T13:04:15Z https://community.qlik.com/t5/App-Development/Two-fields-with-time-values-new-time-related-insight/m-p/1687306#M52361 <P>I've got a CSV table with the following structure (represent inspections), loaded as a table in Qlik (dd-mm-yyyy):</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 212px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/30514iAC0F1A6A52F324FB/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>At an given moment, an inspection is:</P><P>- "Not started" when the given moment is before the "started" date</P><P>- "Open" when the inspection is started before the given moment but is not finished before the given moment</P><P>- "Finished" when the inspection is finished before the given moment.</P><P>&nbsp;</P><P>I'd like to create an insight that weekly (let's say every beginning of a week, started at 01-01-2020) shows how many inspections are "Open", as simple as possible, to see progression. Is it possible to create this insight without creating a new table in Qlik?&nbsp;<BR />- If it is: How could I do this?</P><P>- If not: How could I do this the easiest?</P> Tue, 24 Mar 2020 13:04:15 GMT https://community.qlik.com/t5/App-Development/Two-fields-with-time-values-new-time-related-insight/m-p/1687306#M52361 sandervw 2020-03-24T13:04:15Z