topic Re: Re: Average Calculation - Set Analysis in QlikView

Average Calculation - Set Analysis

Anonymous — Thu, 23 Oct 2014 10:13:40 GMT

Dear Team,

Need your help in set Analysis.

I would like to calculate the average time for each teams excluding the zero hours count.

Kindly refer the "avg calculation" file.Here in row 15 I have updated the required results.The average should be based on only the time which are greater than zero.I have highlighted the greater than times in Green.

If you see "Team3" average it is 16:15,however if we go by only the considered hours(>0) it comes to 32:30.

Could you please help me in arriving the required numbers by set analysis

I am attaching the sample qv file with raw data also for your kind reference

Thanks & Regards

Jeba

Re: Average Calculation - Set Analysis

Anonymous — Wed, 29 Oct 2014 13:10:23 GMT

Dear Team,

Could you please help.

Thanks & Regards

Jeba

Re: Average Calculation - Set Analysis

Wed, 29 Oct 2014 13:19:04 GMT

Hi,

you could use the below expression.

sum(Time)/count(if(Time>0,1,0))

Re: Re: Average Calculation - Set Analysis

lironbaram — Wed, 29 Oct 2014 13:26:32 GMT

have a look

at the attach example , hope it helps you

Re: Re: Average Calculation - Set Analysis

Anonymous — Wed, 29 Oct 2014 13:30:52 GMT

Hi Liron,

Its working perfect.

Great and thanks a lot for youe immediate reply

Thanks & Regards

Jeba