Discussion Board for collaboration on QlikView Scripting.
My QV Table , display total sum wrong. How to make it correct ?
I will post my QV Doc in my next post.
If you are using Straight table then choose some of rows in Expression tab for the expression.
if you can't post a .qvw, post a screenshot of your table to try to help you in the best way.
There is no suficcient information for us to help you. Can you please describe your issue better?
may be anything wrong in your expression??
You are using Pivot table. Take a look here:
incorrect calculated summary in pivot chart
Incorrect totals in a pivot table using set analysis
Wrong total value in pivot table .
Incorrect TOTAL in pivot table
Wrong total in pivot table
Since you are using Pivot table, Sum of Rows option is not available. To get the correct value try like below
=Sum(Aggr(Sum(MeasureName), Dimension1, Dimension2., ......DimensionN))
Note: In above expression replace MeasureName and Dimension1, Dimension2., ......DimensionN with your actual fields.
Hope this helps you.