topic Re: Totals not working in pivot table in QlikView

Totals not working in pivot table

paul_ripley — Fri, 16 Feb 2018 17:06:54 GMT

Hello

I have a table that shows 643 when I just show bud2_line and costc in the pivot table and straight table.

I know this value should be 752

When I add an extra dimension 'text' to the straight table which shows individual lines then the total suddenly becomes the correct number

The pivot table still shows the wrong number ie the individual rows add up to 752 in the pivot table not 643

This is the expression

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},
bud2 = {">0"},
DataSource = {"Agresso"}
>} $(vCurrency))

Could you please help me understand why

a) the straight table total only works with the Text dimension added

b) why the pivot table doesn't work at all even when I add the text

Many thanks

Paul

sunny_talwar — Fri, 16 Feb 2018 17:09:09 GMT

Try this may be

Sum(Aggr(

Sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, bud2 = {">0"}, DataSource = {"Agresso"}>} $(vCurrency))

, bud2_line, text, costc))

paul_ripley — Fri, 16 Feb 2018 17:28:39 GMT

Hi Sunny

Thanks so much for your help, that worked!

Paul