topic Re: InputAvg Limitations? in QlikView

InputAvg Limitations?

paulm — Mon, 07 Jan 2013 09:26:31 GMT

Hi,

I am currently using a number of inputavg pivots one of which is not showing up correctly. I have tried recreating it, analysing the figures below and cannot find any issues. Normal "avg" function works perfect.

Does anyone know a limitation of InputAvg that I could focus my search on?

Thanks
Paul

Re: InputAvg Limitations?

Anonymous — Mon, 07 Jan 2013 09:55:04 GMT

Check that the inputfield has been populated correctly, as if the table it is in is amended after the inputfield is added to it, that inputfield can be changed to some form of autonumber.

Another thing to check, if you are manipulating the inputfield, is whether you should set a distribution mode in the second paramater of the inputavg() function. I usually set this as '*'.

Jonathan

Re: InputAvg Limitations?

paulm — Thu, 31 Jan 2013 15:10:54 GMT

Hi,

Yes the input field had a single duplicate in it which was casuing the issue.

Thanks

Paul