topic Aggregating a sum to different dimensions in QlikView

Aggregating a sum to different dimensions

Tue, 20 Jun 2017 16:53:27 GMT

Hello to everybody! This forum has been a great help so far, but I have found a problem that I haven´t been able to solve using the current available knowledge. First of all, thank you for taking time going through my doubt.

What I am trying to achieve is the expression 1 in the image: to sum every count depending on Dim2 but ignoring Dim1, and using it as it is shown below. The count doesn´t appear like that, but comes from the count operation of different IDs

What I have reached so far, by using this expression =sum( aggr(count({<Dim1>} distinct ID), Dim2)) throws this strange result:

I hope someone can help, and that I will be able to help others in the near future

Kind regards

Re: Aggregating a sum to different dimensions

sunny_talwar — Tue, 20 Jun 2017 17:24:41 GMT

Try this

Count(TOTAL <Dim2> {<Dim1>} DISTINCT ID)

Re: Aggregating a sum to different dimensions

Wed, 21 Jun 2017 07:38:40 GMT

Thank you very much! It worked perfectly. I have one more question:

If we one to select the Dim1 from a list box in order to show only my desired ones, how could I achieve it? Through the formula used above, it always shows every Dim1, no matter whether it is selected.

Thank you very much so far Sunny!

Re: Aggregating a sum to different dimensions

sunny_talwar — Wed, 21 Jun 2017 08:27:29 GMT

That is because of the set analysis you had in your initial post.... try this

Count(TOTAL <Dim2> DISTINCT ID)