I'm guessing that for the Excel total, you are summing rows. QlikView does not sum rows by default, rather it recomputes the total by running the expression over all data. In that way it does not double count a measure that exists in more than one dimension value (rows) on the chart. This is generally considered to be correct.
In a straight table, you cna swtich to "Sum of Rows" if you want on the Expression tab in the "Total Mode" section. In a Pivot table (or any table) you can use the Aggr() that SUmmy suggested to achieve Sum of Rows.
-Rob
