Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks a lot for the suggestion.
I tried the expression you suggested and the totals are now correct.
Thanks again.
Hi,
one more question please.
If I had a subtype, which of the tables in the attached file is correct?
thanks
see attached file
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