topic Re: Field "Duration" mostly empty? in QlikView

Field "Duration" mostly empty?

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi all!

Just ran GovernanceDashboard against a customer's QV11.20SR2 Server&Publisher.

For some reasons only some Publisher tasks have a "Duration". Has anyone seen this before? I think I got the Publisher Date/Time-Format correct (M*/D*/CCYY HH24:MI:SS for 4/3/2014 04:03:15.5474414 ) , however in column "StartedAt" I have mixed notations!

Thx,

Roland

Re: Field "Duration" mostly empty?

Tyler_Waterfall — Mon, 28 Apr 2014 15:36:48 GMT

Try one of these (not sure if you need to add the period):

M*/D*/CCYY HH24:MI:SS[sssssss]

or M*/D*/CCYY HH24:MI:SS.[sssssss]

Re: Field "Duration" mostly empty?

Anonymous — Tue, 29 Apr 2014 07:56:46 GMT

HI Tyler!

Thx, M*/D*/CCYY HH24:MI:SS.[sssssss] worked for me!

Unfortunately now the Field "[Task Duration Bucket]" (used on the Dashboard upper left barchart) is always empty!

Any ideas why this happens?

Re: Field "Duration" mostly empty?

Tue, 29 Apr 2014 08:11:41 GMT

Hi,

Is this the same field?

Re: Field "Duration" mostly empty?

Tyler_Waterfall — Tue, 29 Apr 2014 10:56:59 GMT

Good to hear that the format worked!

[Task Duration Bucket] is a separate field, based on [Duration], as follows:

IF(Duration<61,dual('< 1 Min',1),

IF(Duration<301,dual('1 - 5',2),

IF(Duration<601,dual('6 - 10',3),

IF(Duration<1801,dual('11 - 30',4), dual('> 30',5)

)))) as [Task Duration Bucket]

I'm not sure why that would not be calculating. You could replace the dimension in that chart with a calculated dimension (not great for performance, but should work). In place of Duration, you might try the nested if statement:

IF(Duration<61,dual('< 1 Min',1), IF(Duration<301,dual('1 - 5',2), IF(Duration<601,dual('6 - 10',3), IF(Duration<1801,dual('11 - 30',4), dual('> 30',5)))))

Or the class() function - though this function does not easily allow you to set upper bounds.