topic Re: Error in Total in QlikView

Error in Total

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Dear All!

Please see the data arranged & I have got the latest three Months Average but the total seems to be in correct. I have applied aggr function to correct this but looks like an error in that. Hope some one will help me on this. The formula used given below as an attachment together with excel.

Regds

Neville

Re: Error in Total

pradosh_thakur — Tue, 02 Jan 2018 04:23:47 GMT

Hi Neville

Try this

if (dimensionality()=0,sum(your avg expression) ,your_avg expression) in the expression.Make sure you have not suppressed the nulls. It may be the cause you have data mismatch.If this doesn't work than please post what are the dimension and what are the expressions you are using .

Re: Error in Total

nevilledhamsiri — Tue, 02 Jan 2018 18:17:07 GMT

Hi Pradosh,

I have got the correct total through aggar function but wish to understand about the formula you suggested. Same I have applied but produce error. For your reference total P/T is attached.

Regds

Neville

Re: Error in Total

pradosh_thakur — Tue, 02 Jan 2018 18:28:49 GMT

for total row dimesnionalty =0 , so sum the averages if dimensionality is zero or else just the average.

Re: Error in Total

nevilledhamsiri — Fri, 05 Jan 2018 16:58:24 GMT

Dear Pradosh,

Thanks for your time to help me on the issue highlighted

Regds

Neville