Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Subtotal error in a calculed field

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:

screen.jpg

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
ecabanas
Creator II
Creator II
Author

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
Creator II
Creator II
Author

we could not see the image!!