Solved: Showing column total in a row - Qlik Community

Report Inappropriate Content · ‎2011-05-26

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.

Report Inappropriate Content · ‎2011-05-27

Hi,

Try this formula:

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

tks

View solution in original post

brenner_martina · ‎2011-05-26

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)

Report Inappropriate Content · ‎2011-05-27

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

kaushiknsolanki · ‎2011-05-27

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-27

Kaushick,

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

Look forward to your reply

Dave

kaushiknsolanki · ‎2011-05-27

Hi,

Sorry friend i think its not possible.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-05-27

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]) .

Report Inappropriate Content · ‎2011-05-27

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

pat_agen · ‎2011-05-27

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

sathishkumar_go · ‎2011-05-27

Hi,

Please find the attachments.

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

Regards

Sathish