topic Re: A value which exceeds 24:00 does not show in QlikView

A value which exceeds 24:00 does not show

helen_pip — Wed, 04 Sep 2013 12:56:08 GMT

Hello

I have attached a QVW which shows data from an Inline view statement

The table at the front end shows the longest wait for MonthYear and YTD

However I know for a fact that the longest wait was actually 51 hours or 3105 minutes, but the way I currently have my expression in the table set up is to show the 24 hour clock.

I require help so that the table shows the longest wait even when the wait has exceeded 24:00

Can anyone help me achieve this?

Re: A value which exceeds 24:00 does not show

Gysbert_Wassenaar — Wed, 04 Sep 2013 13:00:15 GMT

Replace the time function with the interval function.

if (Level3_Month='95TH CENTILE',interval(Fractile({<Inline_Monthly_DataSource={ 'ED', 'EYE', 'MIU'} >} Inline_Monthly_Data_A,0.95)/1440,'hh:mm'),

...etc

Re: A value which exceeds 24:00 does not show

helen_pip — Wed, 04 Sep 2013 13:06:04 GMT

Thank you so much

You have no idea how long I have spent tracking back to see where my data was corrupt....Clearly it was a lack of knowledge all along

Thanks

Helen