You can't (as far as I know ) export to excel with the formulas in them. Note that qlik and excel have both different syntax and a different set of functions available.
I might have an idea about what's wrong with your Excel and Qlik sum comparison.
Qlik will per default calculate the total sum of your expression, but when using sum in excel after an export you will sum the row values. The total sum and the sum of rows are not always the same.
Consider this script.
Trips:
Load * inline [
TripId, Origin_Destination, TripCount
1, Stockholm_London, 1
2, Oslo_Copenhagen, 1
3, Reykjavik_London,1
];
Travelers:
Load * inline [
TripId, TravelerType, Name
1, Adult, Vegar
1, Adult, Aanstum
1, Child, Vera
2, Adult, Mike
2, Adult, Vegar
3, Adult, Vegar
3, Adult, Aanstum
3, Adult, Ali
3, Infant, Boy
3, Child, Anna
3, Child, Lars
];
Consider an chart object calculating number of trips containing a certain Traveler type. Using sum(TripCount) per TravelerType.
|TravelerType|SUM(TripCount)|
| Adult | 3 |
| Child | 2 |
| Infant | 1 |
| Total | 3 (as there is only 3 trips)
If you want to show the sum of rows (in this case total=6, then you can change this (when using a straight table) on the measure by adjusting the totaling method to "sum of rows" in the properties for that measure.
