topic Re: Specific total with aggr in QlikView

Specific total with aggr

Mon, 04 Mar 2013 09:11:35 GMT

Hi everybody,

I want to change the formula for a total as a sum of lines and not as sum of the aggr expressions

Here is the file, I hope it is clear enough.

I really need help on this topic.

Best regards

Christian

Re: Specific total with aggr

somenathroy — Mon, 04 Mar 2013 09:31:27 GMT

Hi,

In Expression tab check radio button 'sum of Rows' in Total Mode section.

Regards,

Som

Re: Specific total with aggr

Mon, 04 Mar 2013 10:53:03 GMT

Thank you Som

but this is a pivot table and the option is not available

Regards

chris

Re: Specific total with aggr

Thu, 07 Mar 2013 11:00:28 GMT

Hi Chris,

if you'd want to use a different calculation for the partial sum or sub-totals, use the Dimensionality function. This will give you the flexibility to define what you want to calculate for the totals.

E.g.: I want to calculate the total Quantity for a Region and my first partial sum (on Delete) should show me Average Quantity for that region. But the Final totals should default to total Quantity across all regions.

My expression for QTY2:

(MATCH(Dimensionality(),0),Sum(Quantity)

,If(MATCH(Dimensionality(),1),Above(Aggr(Avg(Quantity),Region),0,RowNo()),Sum(Quantity))

)

Re: Specific total with aggr

Thu, 07 Mar 2013 12:33:21 GMT

Thank you for your answer, but i tried already dimensionality to do sum(QTY2).

But my QTY2 is a result of 4 fileds using sum(aggr(sum( )))

QTY2 = (A * B - C) * D this formula is OK for every line but

For the total i nedd sum(QTY2)

best regards

chris

Re: Specific total with aggr

Thu, 07 Mar 2013 13:57:36 GMT

Upload your sample document. May be I can help you better if I know what exactly you are trying to achieve.

Re: Specific total with aggr

Thu, 07 Mar 2013 14:23:15 GMT

Hi Syed

here is the link to developpement section with qvw

http://community.qlik.com/message/319252#319252

regards

christian