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))
one more question please.
If I had a subtype, which of the tables in the attached file is correct?
see attached file
prova.qvw 9.8 MB