topic Re: No partial sums with dimension selections in QlikView

No partial sums with dimension selections

Fri, 10 May 2013 13:16:02 GMT

I feel that this is a configuration problem, but I can't find another relevant discussion on this. I have a pivot table that without a selection in all dimension will not show partial sums. But if I have a selection in each dimension, the partial sums show.

With Territory and Catalog Section selected, but without Ship To Acct. selected:

With all selected:

The same holds true if I deselect and select Catalog Section.

What am I missing?

UPDATE:

I've narrowed it down to the comparison operator in my expression. If I change my expression from:

=if (Sum({<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}, [Customer Sub Type]={'ENT-Human'}>} [Sales Amount]) <= 0,

Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]={'ENT-Human'}>}[Sales Amount]))

To:

=if (Sum({<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}, [Customer Sub Type]={'ENT-Human'}>} [Sales Amount]),

Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]={'ENT-Human'}>}[Sales Amount]))

...I get my partial sums. Product is wrong; but I get my sums. Anybody?

Re: No partial sums with dimension selections

MEllinghausen — Fri, 10 May 2013 13:23:53 GMT

I think you must check in the präsentation-tab , Dimension chip to acct the "subtototal" box like territory

Marcus

Re: No partial sums with dimension selections

Fri, 10 May 2013 14:02:39 GMT

Thanks for the reply Marcus. I think you're suggesting to make sure the Show Partial Sums checkbox is selected for all dimensions, which they are.

I have discovered though though, that if I change my expression from:

if (Sum({<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}, [Customer Sub Type]-={'ENT-Human'}>} [Sales Amount]) = 0,

Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]-={'ENT-Human'}>}[Sales Amount]))

To an arbitrary one like:

if (0 = 0,

Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]-={'ENT-Human'}>}[Sales Amount]))

The partial sums work. So, I think it has to do with the type of expression. Any ideas?

Re: No partial sums with dimension selections

Fri, 10 May 2013 15:15:50 GMT

Updated.