topic Re: Data Not Showing in QlikView

Data Not Showing

nikhilgarg — Wed, 03 Dec 2014 07:59:39 GMT

Hey,

My data is not showing in the staright table.

Please help.

its_anandrjs — Wed, 03 Dec 2014 08:05:07 GMT

Use this expression

Interval( -(Date([Event Start Time]) - Date([Event End Time]))) as Diff_DownTime

Regards

Anand

MK_QSL — Wed, 03 Dec 2014 08:05:57 GMT

Use something like below in script

LOAD [Event Start Time],

Date([Event Start Time], 'DD.MM.YYYY') as StartDate,

[Event End Time],

Date([Event End Time], 'DD.MM.YYYY') as EndDate,

Time(Frac(Timestamp([Event Start Time])), 'hh:mm:ss') as StartTime,

Time(Frac(Timestamp([Event End Time])), 'hh:mm:ss') as EndTime,

[Event Duration],

[EventState Type],

[EventState Information],

Interval([Event Start Time] - [Event End Time],'hh') as Diff_DownTime