topic Re: Subtotal error in a calculed field in QlikView

Subtotal error in a calculed field

ecabanas — Wed, 10 Apr 2013 11:41:57 GMT

Hi,

I have a table with this expression:

(($(VStock2012)+$(VAd)-$(Vsubs))

/($(VStock2012)+$(VAd)))

*((Today() - MINDATEARTICLE))

this formula calculates the stocking days per article (Dias de cobertura)

And I would like to have this calculation in the total dimension:

Gysbert_Wassenaar — Wed, 10 Apr 2013 17:18:42 GMT

Try setting the Total Mode of the expression to Sum of Rows. See the Total Mode setting on the Expressions tab.

edit: I've tried to add a screenshot, but this site doesn't allow me to add an image anymore. Maybe attaching it is still possible.

ecabanas — Thu, 11 Apr 2013 09:21:43 GMT

Hy Gysbert is not a sum is a calculation.

every row has a calculation, but the total is not a sum of calculations is a aggregate of calculation.

Thank's

Eduard

ecabanas — Fri, 12 Apr 2013 13:47:35 GMT

we could not see the image!!