total does not work correctly

[07mishin]

Good day, who can help me?

My expression: Sum(aggr([finance], [Number], [Number pos]))/1000

I need to count the metric in total so that the filter does not affect.

I try: 

Sum(total aggr([finance], [Number], [Number pos]))/1000

Sum({1}total aggr([finance], [Number], [Number pos]))/1000

But it's not work.

[MindaugasBacius]

Hello,

Read about aggr function: 

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/aggr.htm

https://www.analyticsvidhya.com/blog/2014/02/aggr/

Then try like this Sum(aggr(Sum([finance]), [Number], [Number pos]))/1000

[Vegar · Accepted solution]

It is something odd with your aggr() take a look at @MindaugasBacius  suggestion.

If you want to ignore filters then use set {1}. If you want to ignore the dimensions in your chart use TOTAL. If you want to ignore both filter and dimensions then use both {1} TOTAL.