topic Re: Different Row and Column Totals in Pivot Table in QlikView

Different Row and Column Totals in Pivot Table

kevbrown — Thu, 09 Jan 2014 12:16:11 GMT

I have a straight forward pivot table with 2 dimensions (Status, Date) and 1 expression (Count(ukmpsmr_risk.UMR). When looking at the pivot table (attached) in Qlikview I'm getting incorrect totals for June and October. On the attachment I've created an extra line called Correct Total. Any ideas?

Kev

Re: Different Row and Column Totals in Pivot Table

whiteline — Thu, 09 Jan 2014 17:30:43 GMT

Hi.

The problem is in your data structure (duplicates or something).

For example, if you have one '10' value in a fact table, that is connected with more than one dimension value in other table you get different totals. '10' appears two times (rows) in pivot table for each dimension value but is used only once for total calculation.

Re: Different Row and Column Totals in Pivot Table

kevbrown — Fri, 10 Jan 2014 09:47:01 GMT

is there a way of making the data and totals match?

Re: Different Row and Column Totals in Pivot Table

rajeshvaswani77 — Fri, 10 Jan 2014 10:04:01 GMT

Hi Kevin,

Is it taking values for 2012 as well?

thanks,

Rajesh Vaswani

Re: Different Row and Column Totals in Pivot Table

kevbrown — Fri, 10 Jan 2014 10:07:08 GMT

Only from November 2012

Re: Different Row and Column Totals in Pivot Table

jonathandienst — Fri, 10 Jan 2014 11:10:53 GMT

Kevin Brown wrote:

is there a way of making the data and totals match?

Something like:

=Sum(Aggr(Count(ukmpsmr_risk.UMR), Status, Date))

HTH

Jonathan