Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am having a bit of a problem.
I have data that looks something like this (first three lines):
ID | TIMESTAMP | A | B |
1 | 18.5.2016 18:01 | CLERK | FIRST TOUCH |
1 | 19.5.2016 18:01 | BUSINESS | APPROVE |
1 | 20.5.2016 18:03 | CLERK | ARCHIVE |
We would like to show the most related combination path that is used on this process.
So it would here be Clerk-First Touch -> Business-Approve -> Clerk Archive
I do not now how to produce that kinda field even in Qlik..
I have managed to create a timeline chart, with barchart, that from where we can see the process for each ID when chosing ID.
It is sorted by timestamp, so it is pretty easy to do.
But is it possible to create that process path field in somehow in qlik?
And process path that is aggregated over time, so if we would like to view only certain month or year..
I know this is a lot of asking, but I have absolutely no idea how to do this
P.S. Sample file attached.
Cheers,
Niko
I was wondering, is there a possibility to have a big number out of that most popular path?
So a count from that mode() script? It has aggr() already there, so I think the count is not something that can be implemented to that?
Cheers,
Niko
You can limit the straight table using dimension limits to the max process count, then adjust the format to get something like