Discussion Board for collaboration related to QlikView App Development.
Hello all !
I have a table where there is a sequence of events. Knowing a sequence of (events) lines has a meaning, I want as an output a table where each line correspond to the sequence of lines. To explain more what I want, please see the following:
Thank you very much !
A solution like this one may be suffisant for me where Id is a created field and have its value incremented every time we meet a A event:
you can try with concat:
let vTemp = CONCAT(EventType,'|')
would get you the number of Ev 1 and Ev 2 events, or do you also need the sequence in which Event type 2 happen?
Yes, actually I need both.
But if a have :
ABCD it will count ABC and CD. It wil count C in the two sub strings, and I only want it to be counted in the first one
you can also do:
if( above(Event Type, 2) = 'A' and above(Event Type, 1) = 'B' and Event Type = 'C' , 'Ev 1',
if( above(Event Type, 1) = 'C' and Event Type = 'C', 'Ev 2') as [Event type 2]
this will get messy if there are a lot of event types