Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ashokvelisetty
New Contributor II

Ticket History Inputs-Output's for Team

Hi All,

I need your support to achieve below output format.

I want to set a flags for each 'Team 'input and output when ever ticket enter's into one team we mark as input for that team and whenever it's closed we will make output flag...but problem here we have start date and end date for each records, for some how we have missing time interval in Endtime of one team and start time of next team so we need to create our own start time and end time based on existing data.

Input Flag:

When ticket opened then we can take start time as start time and when ever we have status as closed then that record starttime will be endtime for input flag. 

Output Flag:

When ever ticket is closed that start and end time will be start and end time. If it s inprocess then start and end time will be same for input flag and Output flag.

If i confused you above please see attached sample data and expected output.

Thanks in Advance.

Ashok.

1 Reply
ashokvelisetty
New Contributor II

Re: Ticket History Inputs-Output's for Team

Hi All,

Any suggestions on above scenario.

Thanks,

Ashok.

Community Browser