I have 15 events that each contains a startdate and enddate.
In my set analysis, I'm trying to count the number of occurrences where the first event (1) occurs but event 12,13,14 and 15 does not.
Also, I want to measure the time from event 1 starts to event 12 ends, but if there is no event 12 the latest enddate from event 2 to 11 should be chosen.
So here is example of the data. I want to add a few columns to my pivot table.
An expression where I count the cases where event 1 exists but 12,13 and 14 doesn't (which should be Case A and E)
And secondly an expression where I measure the time from event 1 starts (startdate) to event 12 ends (enddate). (Only case C has both event 1 and 12)
But if event 12 doesn't exist, the time from event 1 starts to any of event 2-11 (enddate) should be measured. Only case E should be measured, according to the data.
From my experiences: the most important thing in qlikview app is data model. It is here much more important, than in any other kind of system. Good data model will do a lot of work for you, making your formulas less complicated. Sometimes it is worth to calculate something during data load, to have easier callculations at run time. I very often calculate some flags to have easy way to check some conditions....
