Calculation Process Variations

[MG82]

Hi,

i try to create an Formualar that I can use to caluclate the diffrent Process Varations in our Organisation. We use a Ticket System whre the Use mark their Status and Timestamp. I want to use these informations to have a string, that is sorted by the rank of the timestamps. 

For Example I use the Excel. Do anyone have an Idea how I can solve this in Qlik.

As you can see, the Ticket abc has passed all the defined Process Steps in the correct way, so I want to create a String that shows me Taskdate1->Taskdate2->Taskdate3. 

The Ticket def has started with Taskdate2 and also finalized Taskdate3. So I need a string that shows these Process steps in a chronological way. Taskdate2->Takdate3

[chrismarlow]

Hi,

This really depends on how your data exists in Qlik Sense and if/how you can change it.

So if the data in your model is in columns like the spreadsheet you would either need to flip it in script to be in rows (i.e. 3 rows for each Ticket for the different Taskdatetimes) and then you have a few options or you don't want to do that you could use a fairly ugly IF statement (which would look a lot like if you did it in Excel) in a chart.

Cheers,

Chris.

[MG82]

Thx Chris, I have an Crosstable based Modell, too.

So each State is row based with unique ID and Datetime. What measuere can I use to rank each unique ID based on Datetime and to convert it to one String.

[chrismarlow]

Hi,

This is QlikView not Qlik Sense but if I have followed right should work in QS;

Cheers,

Chris.

[MG82]

Hi Chris, concat the Dates will not really solve the Problem

The order of the datetimes can be different and I need the Name of the Task, like in example task1-Task3, as concat String, based on the ascending Order by Date.

[chrismarlow · Accepted solution]

Hi,

Hmmm, maybe this?

Cheers,

Chris.

[MG82]

Chris, you made my Day. It works perfectly. Thx