Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anitamanders
Contributor II
Contributor II

wrong subtotals in pivot table

Hello,

I get wrong subtotals in pivot table in row " totaalbedrag inc. korting"

Can someone help me out?

Enclosed file.

Thanks

Anita

1 Solution

Accepted Solutions
jsn
Master
Master

Anita,

It seems like your expression is a little bit wrong.

Currently you have this:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr)/100)*(sum([Factuurregel_perc-krt]))

However, if you change to this I think your totals should match:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr*[Factuurregel_perc-krt])/100)

View solution in original post

1 Reply
jsn
Master
Master

Anita,

It seems like your expression is a little bit wrong.

Currently you have this:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr)/100)*(sum([Factuurregel_perc-krt]))

However, if you change to this I think your totals should match:

sum(Factuurregel_regelbedr) -

(sum(Factuurregel_regelbedr*[Factuurregel_perc-krt])/100)

View solution in original post