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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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