topic Re: total sum is not correct in QlikView

total sum is not correct

Mon, 19 Jan 2015 15:09:55 GMT

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.

Re: total sum is not correct

cwolf — Mon, 19 Jan 2015 17:00:16 GMT

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

Re: total sum is not correct

preminqlik — Mon, 19 Jan 2015 17:03:23 GMT

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))

Re: total sum is not correct

Tue, 20 Jan 2015 09:13:47 GMT

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.

Re: total sum is not correct

preminqlik — Sat, 24 Jan 2015 17:27:35 GMT

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)