This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have some expressions that figure out some timings, but I really need help with getting some highlight on them...
Op time which sums up all the average op time of each procedure that's booked into a session.
op time = Interval(sum( aggr( AvgOp, MPI, AvgOp)),'hh.:mm')
but I need to add 5 minutes turnaround time to each op booked in just to account for any gaps
so my count of ops is: count(EpisodeID)
so I use this to get that into a time plus 5 mins: interval(count(EpisodeID)*5 /24/60,'hh:mm')
then I have session length which is: interval(210/24/60,'hh:mm')
so I was going to use this to total up all the time that will be used in a session: avg op time plus turnaround time
Interval(sum( aggr( AvgOp, MPI, AvgOp)),'hh.:mm') +interval(count(EpisodeID)*5 /24/60,'hh:mm')
so in visual cues i wanted to highlight areas in red if there is no more space to add any more ops:
but this doesn't work - any ideas?
=if(interval(count(EpisodeID)*5 /24/60,'hh:mm')+ interval(sum( aggr( AvgOp, MPI, AvgOp)),'hh.:mm') > interval(210/24/60,'hh:mm') ,1)
I have all the expressions working separately ok - just cant get the highlight to work
Try using background expression rather than visual clues
View solution in original post
arhh ok thanks!
why is that then?, definitely works!
Sunny, yet again, you have provided a solution for an issue I was experiencing!! Don't know what I'd do without you.