However - when I want to do a Box Plot I need an expression - My current expression will not work.
I have tried
a. adding another sql script which will output Person, Activity, DateTime
b. using the formula
if(Person= Previous(Person), Activity2Act_DtTm - previous(Activity1Act_DtTm)) as planTurn
However planTurn using this way does not always match what using the formula will give me.
So I would prefer to use the formula - but the values appear to be hard coded - they do do not change with the calculated planTun (that is calculated within the Qlikview script ???) And I cannot show the legend.
I think the problem might be that I need to go back to the design.