Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
;
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 .
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
;