Discussion board where members can get started with Qlik Sense.
i want an expression that can give me a result like "Result from Expression" field shown below-
result from expression
the idea is that, i want to get the "response start" and "resolution start" according to the keyword 'forward" for every ticket's action .
try like this:
NoConcatenateOUTPUT:LOAD *,If(action='forward',If(Previous(action)='forward','resolution start','response start'),'') as new_fieldResident ...Order Byticket,action;
View solution in original post
Hi, Please try if(action = 'forward' and peek(id)=id, 'resolution started','response started')
thanks a lot for the reply,
i am unable to find the desired result, please see what i am getting as a result by applying your suggested expression.
if the 'forward' comes first time for a distinct ticket then that should be "resolution start"
if the 'forward' comes for second time them that should be "response time" for that distinct ticket .