topic Re: Ignoring running selection on running dimension in Aggr in QlikView

Ignoring running selection on running dimension in Aggr

Wed, 31 Aug 2016 15:11:58 GMT

Hi everyone, I'm currently struggling with a problem for which I really need your collective wisdom.

Here is the situation: I have a data model which includes an aggr function. The aggr function runs over a particular dimension, on which the user has made selections. Thing is, I want to ignore the selection and calculate over all possible values of the dimension.

I've reduced the problem to this simple example, in which the aggr looks like: "=sum( total aggr(1, A)"

Without selection on A, the results look like we want them:

But when I select values in A, it only runs over those values instead of over all:

In both the textbox and the table, I still want the values to read 5. I've tried a lot of combinations using set analysis, but can't get it to work.

I'm including the example above.

Re: Ignoring running selection on running dimension in Aggr

sunny_talwar — Wed, 31 Aug 2016 15:41:51 GMT

May be try this:

=Count({1}TOTAL A)

Re: Ignoring running selection on running dimension in Aggr

sunny_talwar — Wed, 31 Aug 2016 15:43:01 GMT

And this for text box object

='Total sum: ' & Count({1}A) & '

(should be 5)'

Re: Ignoring running selection on running dimension in Aggr

Thu, 01 Sep 2016 06:53:35 GMT

Hi Sunny,

You are right, for this simplified example this would work.

Unfortunately, our real-life situation is a bit more complex and the equation looks something like this:

=firstsortedvalue(name, aggr(sum(value), name))

We haven't figured out a way to do this without the aggr.

Thanks!

Re: Ignoring running selection on running dimension in Aggr

sunny_talwar — Thu, 01 Sep 2016 10:23:42 GMT

May be try this:

FirstSortedValue({1} name, Aggr(Sum({1} value), name))