Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Searching Data in a Status-Flow


I have a dataset here and I'm not sure what the correct approach here is:

There is a base table, let's say "orders".

Each record of these orders have historical data in a linked table: "Status-History" with fields "status" and "date".

So for example for order 1 you find:

03/03/2011: Opened

04/03/2011: Reviewed

08/03/2011: Closed

10/04/2011: Opened for review

11/04/2011: Adjustment made

19/04/2011: Review closed
14/07/2011: Appeal

03/08/2011: Appeal Denied

07/10/2011: Removed

(any combination of these statusses are possible)

How would I load this so I can show things like:

- All orders opened or opened for review in a month and how many of them have been closed meanwhile.

- How many orders are removed which did not have had an appeal before

- How many tickets are in the status of their first Appeal

- ...

If someone has some idea's he'd like to share !

Thanks in advance