topic Re: Total vs {1} Total in QlikView

Total vs {1} Total

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Total vs {1} Total

sunny_talwar — Thu, 16 Mar 2017 13:02:59 GMT

I think this would be the best place to look

The Aggregation Scope

Re: Total vs {1} Total

Thu, 16 Mar 2017 13:45:33 GMT

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

Re: Total vs {1} Total

swuehl — Thu, 16 Mar 2017 13:46:30 GMT

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

Re: Total vs {1} Total

sunny_talwar — Thu, 16 Mar 2017 13:47:02 GMT

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...

Re: Total vs {1} Total

sunny_talwar — Thu, 16 Mar 2017 13:49:09 GMT

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

Re: Total vs {1} Total

swuehl — Thu, 16 Mar 2017 13:49:20 GMT

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

Re: Total vs {1} Total

sunny_talwar — Thu, 16 Mar 2017 13:50:07 GMT

I guess you are right

Re: Total vs {1} Total

Thu, 16 Mar 2017 14:01:35 GMT

Thank you Sunny, stefan