topic Re: Showing column total in a row in QlikView

Showing column total in a row

Thu, 26 May 2011 15:01:20 GMT

Hi,

I want to show the total of colmun Moving Range (which we can see is equals 14) in the Total moving range column. I think the formula should be

sum(total [Moving Range]) but for some reason not working. Does anyone know where I am going wrong?

Thank you for your help.

Showing column total in a row

brenner_martina — Thu, 26 May 2011 16:03:51 GMT

Hi,

you can not use the Column Name [Moving Range] for sum Total, you must use the fieldname or the whole expression of the column [Moving Range], somethiong like:

sum(total Sales)

Showing column total in a row

Fri, 27 May 2011 09:48:30 GMT

Brenner,

I have tried to insert the formula instead sum(total [fabs(above(DataPoint)-DataPoint)) but still does not work, any suggestions?

Thank you

Dave

Showing column total in a row

kaushiknsolanki — Fri, 27 May 2011 10:04:39 GMT

Hi,

Do you mean to say You want to show 14 in every row.

Regards,

Kaushik Solanki

Showing column total in a row

Fri, 27 May 2011 10:06:35 GMT

Kaushick,

Yes, I can then use this for some other calculatioins.

Look forward to your reply

Dave

Showing column total in a row

kaushiknsolanki — Fri, 27 May 2011 10:18:58 GMT

Hi,

Sorry friend i think its not possible.

Regards,

Kaushik Solanki

Re: Showing column total in a row

Fri, 27 May 2011 10:19:31 GMT

Haycockd, i opened your file and i didnt reach your issue.

If u r trying to get the cummlative total u can use different expression into Total Moving Range:

fabs(above(DataPoint)-DataPoint)) + if( rowno()=1 or rowno()=2, above ([Total Moving Range]) .

Re: Showing column total in a row

Fri, 27 May 2011 10:30:55 GMT

No don;t need the cummlative total all I am treying to do is show the total of moving range in the total moving range column .

As you can see in my total if we add together the moving range it equals 14. I want this figure repeated in each of the Yearmonth rows.

This is something I can easily do in excel so finding it very frustrating.

Thank you for your help

Re: Showing column total in a row

pat_agen — Fri, 27 May 2011 10:52:13 GMT

hi,

the difference being that in xl you can reference the cell that contains the value 14 from your chart.

In Qlikview you cannot do this - you have to be able to replicate the calculation. As your calculation references lines dynamically - using the above function - I would agree with Kaushik in saying this wont be possible.

However if you calculate this at script run time the value you have in the "Moving range" column can then be as easily summed and used as the DataPoint column.

This is one area where qv is different from xl.

see attached qvw

Re: Showing column total in a row

sathishkumar_go — Fri, 27 May 2011 12:41:06 GMT

Hi,

Please find the attachments.

I hope this is what u r looking!!!!!!!!!!!!!

Regards

Sathish

Re: Showing column total in a row

Fri, 27 May 2011 15:32:26 GMT

Hi,

Try this formula:

BOTTOM(RANGESUM(RANGESUM(fabs(above(DataPoint) - DataPoint)), ABOVE(RANGESUM(fabs(above(DataPoint) - DataPoint)), 1, ROWNO())))

tks

Re: Showing column total in a row

Fri, 27 May 2011 15:37:34 GMT

Ecorrea, your a genius. Thank you so much, works a treat.

Dave

Showing column total in a row

pat_agen — Fri, 27 May 2011 15:52:35 GMT

hi ecorrea,

not for the first time I see things on this community which I didn't think were possible. Very impressive.

have a good weekend.