Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with total expression in qlik pivot table

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

4 Replies
Not applicable
Author

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.

Not applicable
Author

Thanks a lot for the suggestion.

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

Thanks again.

Not applicable
Author

Hi,

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

see attached file

Not applicable
Author

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