Straight table not displaying negative time value

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table that displays the smallest value of a given field (expression= "Min({<Ward={'NSEC08'}>}[Difference between bed reserved time and PAS time left])" ) which seems to work fine apart from when it comes across a negative value (due to people incorrectly entering the right values).

Is there anyway to just either blank the value or at least identify it with a minus sign.

Thanks,
Peter

Re: Straight table not displaying negative time value

peterderrington — Wed, 06 Nov 2019 17:01:00 GMT

Its ok, i worked it out.

I used this expression and it now shows the first true minimum value:

Min({<Ward={'NSEC08'},[Difference between bed reserved time and PAS time left]={">00:00:00"}>}[Difference between bed reserved time and PAS time left])

topic Straight table not displaying negative time value in QlikView

Straight table not displaying negative time value

Re: Straight table not displaying negative time value