topic Re: Problem with total expression in qlik pivot table in QlikView

Problem with total expression in qlik pivot table

Tue, 02 Aug 2011 13:19:12 GMT

Hi, I have two pivot tables.

In the table where the expression is a count of the

serial number, row and column totals are correct.

My problem is that the table where the expression is a count (distinct) of

the serial numbers, row totals are correct while those of column

Wrong.

I attach the QlikView file to expose the problem.

Can anyone help me solve the problem?

thanks

Re: Problem with total expression in qlik pivot table

Tue, 02 Aug 2011 13:32:23 GMT

Hi there, the columns totals are not wrong from qlikviews perspective, because it is actually counting all the distinct values regardless of the dimensions, for instance, there might be some "Seriale" that are common for more than one "Comune", however, if would like the total to express the sum of all rows, use the following expression:

sum(aggr(Count (distinct Seriale),Comune, Tipo))

Regards.

Problem with total expression in qlik pivot table

Tue, 02 Aug 2011 13:49:56 GMT

Thanks a lot for the suggestion.

I tried the expression you suggested and the totals are now correct.

Thanks again.

Re: Problem with total expression in qlik pivot table

Wed, 03 Aug 2011 14:27:02 GMT

Hi,

one more question please.
If I had a subtype, which of the tables in the attached file is correct?
thanks

see attached file

Re: Problem with total expression in qlik pivot table

Wed, 03 Aug 2011 15:02:31 GMT

Hi, I just saw your document, and I can tell that both tables below the screen are correct when you add the sottipo dimension. The main key here, is to consider every dimension you include or you may include in your graphic within the aggregate function, as you already figured out.

Regards