Two fields with time values, new time related insight
I've got a CSV table with the following structure (represent inspections), loaded as a table in Qlik (dd-mm-yyyy):
At an given moment, an inspection is:
- "Not started" when the given moment is before the "started" date
- "Open" when the inspection is started before the given moment but is not finished before the given moment
- "Finished" when the inspection is finished before the given moment.
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? - If it is: How could I do this?