Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total vs {1} Total

hi,

I used following statements.

1. Sum({1} TOTAL Sales) - Take sum of sales & doesn't change if you select any filter ( city, region, year etc)

2. Sum({1} Sales) - Take sum of sales & doesn't change if you select any filter ( city, region, year etc)

if both works same then what is use of TOTAL here?

could anyone explain me in what scenario we should use it?

8 Replies
sunny_talwar

I think this would be the best place to look

The Aggregation Scope

Not applicable
Author

Nice article but my question still remains. if both works same then what is use of TOTAL here?

swuehl
MVP
MVP

The article should explain that there is a difference when you are using the expression in a chart with dimensions.

sunny_talwar

If they both are getting used in a text box, then having a total doesn't make any difference, but in a straight table or pivot table, the two expression will give different results..... Sample to follow...

sunny_talwar

Check out how Sum({1} TOTAL Sales) gives me 30 for both rows, whereas Sum({1} Sales) give 10 and 20

Capture.PNG

swuehl
MVP
MVP

You are too kind, Sunny. It's explained quite well in the blog post you linked to... Including sample.

sunny_talwar

I guess you are right

Not applicable
Author

Thank you Sunny, stefan