total sum is not correct

[#1]

Hi everybody,

I have a problem with a sum in Qlikview.

The column DefTax STBADJ is calculated with a percentage. The percentage is dependant on the KontoID.

The Detailed lines are correct, but not the TotalLines [called "Gesamt"].

DefTax STBADJ:

=

if(KontoID='60740', -Körperschaftsteuersatz*[Akt. Jahr STBADJ], if(KontoID='60746',-Gewerbesteuersatz*[Akt. Jahr STBADJ],
-Unternehmenssteuersatz*[Akt. Jahr STBADJ]))

I think the Total-Line is calculating with the percentage from the Total-Line.

But this should not be done.

Does anybody knows a solution?

Very much thanks in advance.

[cwolf · Accepted solution]

Hi Christian,

You have in your expression no any aggregation such Sum() or others. Without them a correct total can not be calculated. Totals calculated Qlikview in a pivot table always by using the expression over all possible data lines.

Regards

Christian

[preminqlik]

hi try this

sum(aggr(sum(if(KontoID='60740', -Körperschaftsteuersatz*[Akt. Jahr STBADJ], if(KontoID='60746',-Gewerbesteuersatz*[Akt. Jahr STBADJ],
-Unternehmenssteuersatz*[Akt. Jahr STBADJ]))),TaxCode,BS_Line,KontoID))

[#4]

Hi everybody,

thanks for you help. Now I got in every line 0,00.

So I think it is not working. I want the correct amount in the "partial sums" line.

So additional help would be very welcome.

[preminqlik]

so do one thing make another expresiion for check

=dimensionality()

and according to above resulatnt dimensioanlity value , write expression like below :

if(dimensionlity()=1,exp1,exp2)