topic total does not work correctly in App Development

total does not work correctly

07mishin — Fri, 17 Dec 2021 07:05:07 GMT

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.

Re: total does not work correctly

MindaugasBacius — Fri, 17 Dec 2021 07:27:12 GMT

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

Re: total does not work correctly

Vegar — Fri, 17 Dec 2021 07:46:43 GMT

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.