# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## total field

Hi !

I have table with expression (FACT 2012):

sum(if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

How can i get field with total sum?

Tags (3)
1 Solution

Accepted Solutions
MVP & Luminary

## Re: total field

Try adding total <Dim1,Dim2> to the sum expression. Replace Dim1 and Dim2 with the first two dimensions of your pivot table.

sum(total <Dim1,Dim2>  if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

See attached example for how it works.

talk is cheap, supply exceeds demand
6 Replies
Not applicable

MVP & Luminary

## Re: total field

Try adding total <Dim1,Dim2> to the sum expression. Replace Dim1 and Dim2 with the first two dimensions of your pivot table.

sum(total <Dim1,Dim2>  if((Aggr(sum({<year={"2012"}, bg_t={'*'}, bg_t-={'b\g}, Holding=>} Quantity),AffiliateID, Holding,mes))>0 ,1,0))

See attached example for how it works.

talk is cheap, supply exceeds demand
Not applicable

## Re: total field

Thank you, Gysbert for your help!

I put exemple in you attachment, please look

MVP & Luminary

## Re: total field

Hi,

Try this expression

sum(Total<Year, Product, Region>if((Aggr(sum({<year={"2008"}, Product={'*'}, product-={'Banana'}, Holding=>} Sales),Year, Product,Month))>0 ,1

,0))

Regards,

jagan.

Not applicable

## Re: total field

thank you very much!

Not applicable

## Re: total field

thank you, it works