Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sandervw
Contributor
Contributor

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):

image.png

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?

- If not: How could I do this the easiest?

0 Replies