topic Partial Sum in QlikView

Partial Sum

Thu, 12 Nov 2009 17:32:04 GMT

Hi everyone,

Could any one please help?

My problem is that the partial sum in the pivot table shown me a value "-" (Null) . But I have figures for every rows above it. Also, there are all numbers as well. There are field data from excel file directly. Do anyone have any thoughts?

Another question:

I have used sum(Amount)/sum(total<Field="A">Amount) in my expression. It works fine. And I can get the partial sum of it. But when I use it for further calculation, it doesn't work. For exampl

expression = sum(Amount)/sum(total<Field="A">Amount) + Cash

Both work fine individually, but not after addition....why....I get "-" for every single cell

Many thanks,

Ivan

Partial Sum

Thu, 12 Nov 2009 19:30:30 GMT

Hi Ivan,

maybe you should take SUM(Cash) as well. in stead of Cash only.

If you have more values of Cash QV doenst know which field to take

Rey-man

Partial Sum

Thu, 12 Nov 2009 19:42:57 GMT

Thanks for your reply.

I have solved that problem by chance. What I had before: Column(1) + Column(2), where Column(1) is the one with long formula, Column(2) is Cash.

They both work fine individually, but not after addition.

What I have done was: demote Column(1) to Column(3). Then use formula Column(3) + Column(2) (Cash has no change). By magic, it works suddenly.

However, I am still working on the problem on partial sum...I have figures one every rows, but partial sum gives me "-".....I am try to change the origin data in Excel from formula to value (hope i can solve it by luck again).

Thanks,

Ivan

Partial Sum

Tue, 24 Nov 2009 23:20:13 GMT

In the columns where data is not coming, say column1; is the expression:

=column1

If it is then change it to =Sum(column1) and it should work.

Partial Sum

Tue, 24 Nov 2009 23:48:33 GMT

In some cases maybe your denominator is 0 which means a DIV /0 that can give you a null value ?

Partial Sum

Wed, 25 Nov 2009 00:12:27 GMT

Thanks for everyone's helps. I have solved it. The reason is that data are from from level. Therefore, the expression total in pivot table is not working. To solve it, I have use aggr in my expression.

Ivan

Partial Sum

Wed, 23 Mar 2011 07:54:18 GMT

Hi,

I am stuck with similiar issue, can you pls share the expression sample ?

Thanks

jeswanth

AW:Re: Partial Sum

brenner_martina — Wed, 23 Mar 2011 08:41:15 GMT

Hi,

Aggr is easy and works with one or more dimensions:

Sum(Aggr(your_expression),Dimension1,Dimension2,...))

Partial Sum

Wed, 23 Mar 2011 09:29:55 GMT

select that field on which you want to do partial sum and tick the partial sum box in pivote tables properties