topic Re: Set a maximum value during load? in QlikView

Set a maximum value during load?

Wed, 16 Jan 2013 20:11:13 GMT

I am looking at analyzing large data sets for completed jobs and calculating the utilization percentage each employee spent per day. This is down by counting up all of the minutes they reported as completion time and then dividing by the total number of minutes on the clock.

The problem is that the underlying system supplying the data allows for some strange results where jobs may take several days and this results in a comple of jobs each day that are 10,000 minutes. This obviously skews the data.

Is there any way that I can limit the loaded value in Qlikview? For instance, if the completed job takes over 180 minutes then the loaded value is limited to 180?

I am pretty sure that I am going to have to fix the source file, was just hoping their might be a more elegant way out.

Re: Set a maximum value during load?

danielrozental — Wed, 16 Jan 2013 20:19:26 GMT

Sorry, I don't really follow you, why can't you just use an if?

LOAD *, if(MINUTES > 180, 180, MINUTES) AS MINUTES_CORRECTED

FROM SOURCE

Re: Set a maximum value during load?

Wed, 16 Jan 2013 20:25:39 GMT

Thanks, that seemed to work.

I am very new to Qlikview/programming in general and haven't really explored the Load options i may have.

Thanks again