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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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