how to identify action taken according to the fields value?

[raZor]

Hello Qlikers,

i want an expression that can give me a result like "Result from Expression" field shown below-

ticket	action	result from expression
a	action1
a	forward	response start
a	action2
a	forward	resolution start
a	action3
a	action1
b	action2
b	forward	response start
b	forward	resolution start
b	closed

the idea is that, i want to get the "response start" and "resolution start" according to the keyword 'forward" for every ticket's action .

[premvihari]

Hi, 

Please try 

if(action = 'forward' and peek(id)=id, 'resolution started','response started') 

[raZor]

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.

[raZor]

[raZor]

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 .

[StarinieriG · Accepted solution]

Hi

try like this:

NoConcatenate
OUTPUT:
LOAD *,
If(action='forward',If(Previous(action)='forward','resolution start','response start'),'') as new_field
Resident ...
Order By
ticket,
action
;